can i link pivot tables

[Peter]

I have two pivot tables that get there source data from different files. I
would like to link the fields from both pivot tables into one spreadsheet
that will update when the pivot tables are updated.

 

[ryguy7272]

Hope this gives you what you want:
http://www.contextures.com/xlPivot08.html

If that doesn't do it, look here:
http://www.contextures.com/xlPivot07.html