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"

Sub refreshPivots()

Dim pt As PivotTable
    For Each pt In ActiveSheet.PivotTables
        pt.RefreshTable
    Next pt

End Sub

Thanks in advance

Try

Sub refreshPivots()

Dim pt As PivotTable
    For Each pt In Sheets("My custom sheet").PivotTables
        pt.RefreshTable
    Next pt

End Sub

Thanks a lot!