Need help for Pivot Tables

[ThrottleWorks]

Hi Experts,
I need your help. Please help me if you get time.
I have a worksheet.
This worksheet has n number of pivots.
I want to extract base data of each pivot table in a new worksheet.
Just like how we do manually, we select last cell of pivot table and double click on it to see base data table.
I want to do this with VBA. Can you please help me in this.

 

[AlanSidman]

See if this video helps you

 

[ThrottleWorks]

Thanks for the help @AlanSidman , have a nice weekend.