control your sheets data filter with one sheet

[tinkode]

i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them

Exemple like in the picture

 

[tinkode]

uppp plz help

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...sheets-data-filter-one-sheet.html#post5289589

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).