how to create a separate sheet listing specific contents of another?
Here's the context:
There's a recording studio complex containing three seperate studios; studio 1, studio 2 and studio 3.
I have created a Numbers document with a Main sheet listing ALL of the equipment in the complex. The table in this sheet details the make and model of each piece of equipment, its value, serial number etc etc... There's a column called 'Location' listing which of the three studios each piece of equipment is in.
I now want three sererate sheets for each of the three studios and ideally the tables in these sheets will automatically update depending on what is written in the 'Location' column of the Main sheet.
Can somebody please tell me if this is possible and if so, how? If not possible, what would you suggest as an alternative?
Thanks you very much in advance,
Joseph
iWork Numbers-OTHER, OS X Mountain Lion (10.8.5)