i already have my code that works fine if i keep the index on the same page as the pivot but i am trying to get it to look at another cell in a different worksheet

the code i have got already that works is this

Sheets("PVT").Select
ActiveSheet.PivotTables("PivotTable6").PivotFields("Project Name"). _
ClearAllFilters
ActiveSheet.PivotTables("PivotTable6").PivotFields("Project Name").CurrentPage = Range("A1").Text

but where i have - .currentpage = range("a1").text - i want it to pick up from a the sheet called summary

ive tried replacing the info with sheets("summary).Select CurrentPage = Range("a1".text but doesnt work

can you help

thanks