PowerPivot from Multiple Excel Files
http://www.contextures.com/PowerPivot... Combine data from multiple Excel files and create a summary report with the PowerPivot add-in for Excel 2010.
Modify the SQL statement to create a union query and combine all the data into one table.
The sample file is available on the Contextures website: http://www.contextures.com/PowerPivot...