GETPIVOTDATA
Lookup

Returns data stored in a PivotTable

Syntax:

=GETPIVOTDATA(data_field, pivot_table, [field1, item1, ...])

Example:

=GETPIVOTDATA("Sum of Sales",A3)