JN,

Don't use separate sheets - generally, a bad idea - just apply data filters
and choose the desired stockroom from the drop down. And you can use pivot
tables to create summaries.

HTH,
Bernie
MS Excel MVP


"JN" wrote in message
...
I have a worksheet that has a list of parts and the stockrooms they are in.
I want to have one sheet will all the raw data like so:

STOCKROOM PARTNUMBER QTY
----------------------------------------------
MAINSTOCK 123456789ABC 100
AUX-STOCK 123456789ABC 100
FINISHEDSTK XYZXYZ12345 500
MAINSTOCK XYZXYZ12345 100

And then create separate worksheets with the stockroom name in cell A1.
Based on A1 (Stockroom name) I want the remainder of the sheet to be
filled with all the rows from the Raw Data sheet so when I add or refresh
data each of the other sheets will refresh with the correct information.