Hi

I have created a simple macro to perform a task to put some data into pivot
table. The only problem I have with this is that before I run the macro I
will always have to change the Sheet Tab parameters to exactly whats on the
macro ('Gqs 29')see below. Is it possible for me to change this so it works
on any spreadsheet and any tab without me having to always rename the tab Gqs
29 before the macro works?

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"'Gqs 29'!R21C2:R65536C8").CreatePivotTable TableDestination:="",
TableName _
:="PivotTable2"