Cell Referencing?
 

I have spreadsheet with a shopping list. Once the quantity is updated, the
information is moved to another worksheet. I have several of these worksheets
for different departments. (For more detailed information search for 'Moving
information' in Excel worksheet functions, its the one with 8 posts)

The information is moved to the other sheet by the following formula (THANKS
TO MAX!):
=IF(ISERROR(SMALL($D:$D,ROW(A1))),"",INDEX(X!A:A,M ATCH(SMALL($D:$D,ROW(A1)),$D:$D,0)))

=IF(X!B20,ROW(),"")

I need the information derived from the above formula for each of the
departments to all be on one worksheet. . I tI have tried copying and pasting
the formula from each worksheet but it does not workhink there is an issue
with the cell referencing. For example in cell A1 the information for Dept 1
would begin. In cell A80 information for Dept 2 would begin. I have tried
placing the above formula to in cell A80 and changing the Worksheet (Index)
to the other worksheet but it still does not work.

I would really appreciate any assistance!

Thanks once again!