Update pivot tables based on source data filter

Hi

wondering if someone could assist with the below

i have 5 pivot tables on 5sheets, all looking at the same source data in sheet 6

on the source data there is a filter on the headers, if you change the filter, is it possible for all 5 pivot tables to update according to the filter?

Many Thanks

Please Login or Register  to view this content.

my starting point

but i need the source data to point to the viewable data by filter in a sheet