Pivot tables

[PK]

I would like to have data from two different worksheets on the same Pivot
table is this possible.
For example I have a spreadsheet with information relating to the year
2004/05 and a spreadsheet with the same type of information relating to
2005/06 to allow me to compare the both I would like to put them into a
single pivot table and then into a single chart.

 

[Debra Dalgleish]

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

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