Selecting a Pivot Table on a sheet and not caring about the name

Is there anyway to make it so that

Please Login or Register  to view this content.

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

Try

Please Login or Register  to view this content.

Or in your bigger quest you can use something like

Please Login or Register  to view this content.

Thanks, Didn't consider your solutions, but seem good!

I ended up just copying the columns instead