Tool to automatically combine many large pivot table in many large Excel sheet?

We have several Excel files that contains large pivot data table with the same structure

For example

File A

Pivot table (Field A, B, C)

File B

Pivot table (Field A, B, C)

We want to combine them into 1 pivot table (A, B, C). Just want to know which ways we can do it ?

• 
  

  Manual way : open a new empty sheet, copy and paste the pivot there and create the pivot again

  
  


• 
  

  Automatic way : is there some tool that did this ?

  
  

Thanks