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.