ActiveSheet.PivotTables => How to do it for custom sheet? (replace ActiveSheet)

Hi, I want to refresh all PivotTables in a customized chosen sheet.

I found a code how to do it in the activesheet.

How can I replace ActiveSheet with a custom sheet? Let's say I want to update all PivotTables in the sheet "Table1"

Please Login or Register  to view this content.

Thanks in advance

Thanks a lot!