Can I extract data from a pivot table using labels?

[TheRedCardinal]

I have a pivot table that has the following parameters:

Rows:

1. Partner ID 1
2. Partner ID 2
3. Indicator

Values:

1. Total Values

I want to copy the data only (i.e. not headings) from the following columns:

1. Partner ID 1
2. Partner ID 2
3. Total Value

I want to paste them (as text) into specific columns in another worksheet.

I can do this using the normal "Find column header / find last row, copy range" method but is there a better way i.e. by referencing the row headers themselves within the PivotTable object?
I tried to use the recorder to give me a clue on this one but it just selected ranges when I did it, so no help there.