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

"this may come a bit late but what you can do:

create a pivot table linked to an external data source:

data source=access file. don't use this wizard, use ms query. there you can create a query that combines several tables as data sources and combines them into one table. you will never see the actual query output in excel, but the pivottable will be based on it.
data source=excel file. point the file selector to itself (=the excel file you are using), then you can use all named ranges as tables and do the rest just as you were using access as the data source. for this you will need to put all input data into named ranges, where the first row are the column headers. warning: if you rename the file or saveas different file, the underlying query of your pivot table needs to be redone as the data source is not dynamic. i think that one can also use either pivottables or querytables or both directly as input sources without going via named ranges, but this would probably require vba."