Get Data from Pivot Table

[aikz007]

Hi All,

Have any idea how to do this?, On the first workbook i have the data and the pivot table. On the second workbook I want to extract the data from the pivot table based from the value on cell A2.

Any help would be much appreciated.
SampleFile.xlsxGet Data.xlsx
Thanks

[aikz007]

I've found a code that changes the filtered value based on a cell. Any idea for this link to work on a separate workbook?

SampleFile.xlsm