Is there anyway to make it so that
ActiveSheet.PivotTables("PivotTable1").PivotSelect
the "PivotTable1" does not mater when selecting the Pivot table on a given sheet?

I plan to Filter Pivot tables to all sheets and have a code that Copies each pivot -after selecting the pivots respective sheet