Single Pivot Table from multiple spreadsheets

[John Foster]

I am looking for a little advice as how to handle this situation best. I
have several Excel documents that I would like to summarize and put into a
Pivot Table. This is basically a timesheet summary utility. Our
organization uses an Excel template for our timesheets. I would like be
able to import a certain range of timsheets into a query or pivot table for
analysis and breakdown.

How can I best accomplish this?


thanks...

 

[nobody]

When going through the Pivot table wizard, choose multiple consolidation
ranges. This should also work with multiple workbooks as well as long as you
"show it" where these files are