Using Excel 2007, how do you create a pivot table using multiple ranges?
The option does not appear in the Create Pivot Table wizard.

I thought I could use something like this: 'Page 1'!$A$6:$T$28805:'Page
2'!$A$6:$T$28805 ; but it wasn't accepted as a valid range.

Thanks,

Ross