Apply filter from Sheet 1 to Sheets 2 and 3 (1 Viewer)

[NearImpossible]

I have a workbook with multiple sheets and what I would like to do is be able to filter the data on Sheet 1, using the filter selections (Data > Filter), and then auto filter Sheets 2 and 3 to only show the selected filters from sheet 1.

Example:

I filter Column 1 on Sheet 1 and only select Fac 1 and Fac 2, when I click on either Sheets 2 or 3, i would like only Fac 1 and Fac 2 displayed on those sheets as well, etc. vs having to reapply the filter on each sheet.

In the end I will have 5 or 6 different Sheets with different information in Columns E-L, but Columns A-D will be the same on each Sheet

Is this possible?

please advise

thank you

 

[Gasman]

Look at the Worksheet_Change event to apply the filter to the other sheets.
Use the Macro recorder to get the basics, and amend that code.