See attached excel file.
We have a master list of data on Sheet 1. We have 3 other sheets representing different locations (Level 1, Level 2, Level 3). The Location is defined in column F.
We would like the other sheets to read from the master sheet and only display the data that is appropriate for that given location. I have filtered the data manually and copied it to the sheets, to show what we want as an end result. However, we need this automated, so that if we make a change in Sheet 1, then there will also be a change to the other sheets.