Microsoft Excel: Make GetPivotData() refer a pivot table using its name
According to the documentation here, pivot_table
must be:
A reference to any cell, range of cells, or named range of cells in a PivotTable. This information is used to determine which PivotTable contains the data that you want to retrieve.
So, the short answer to your question is "No".
However, you can create a named range, pointing to the upper-left cell of the pivot table, that has the same or similar name to your pivot table, then refer to that named range in the formula.