Without grouping the sheets, make the following calculations in both worksheets:

In cell G$14$ type Stock Level.

In cell G$15,$ enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than $75,$ the Value if true is Order. Otherwise, the Value if false is OK$.$ Fill the formula down through all the rows.