Pivot table, data from various spreadsheet

[Derrick]

I have data in 3 separate spreadsheets (in the exact
format). I want to have a pivot table that consolidate
data from these sheets.

Is this possible?

 

[Max]

Try Debra's page on:

Excel -- Pivot Tables -- Multiple Consolidation Ranges

at: http://www.contextures.com/xlPivot08.html