A macro is the easiest way to do this. This macro applies an AUTOFILTER to the Master sheet, it finds all the rows with an "x" in them in the column that matches the NAME of the sheet, then it copies all those matching rows to the sheet.
This macro occurs automatically each time you view any sheet in the workbook. It triggers automatically on every sheet except the MASTER.
To insert this macro into your workbook:
1) Press Alt-F11 to open the VBEditor
2) On the left-hand project panel, locate the THISWORKBOOK module and double click it to open it
3) Paste the code given above into the module window that opens
4) Close the VBEditor, and save the workbook.
Now just navigate your workbook... when you look at the PHYSICS sheet, the macro will bring all the physics data in fresh, each time.
Bookmarks