How can I find Pivot Table Sheet for Pivot Chart?
 

I have a workbook with a bunch of pivot charts where the pivot tables are
hidden to make it clean.

I want to put a button on the chart that finds the correct pivot worksheet
for the selected pivot chart, unhide it, then activate that pivot sheet.

Any ideas how to determine the Pivot Table Worksheet Name?

The other logical question....
Is there a way to find and activate any charts that use the currently
selected pivot table as source data?

Thanks
MikeZz