Pivot Tables

[TBird]

I developed a pivot table using multiple consolidation
ranges from three seperate sheets in the same workbook.
Now I want to add more sheets. How do I do this without
re-creating the whole pivot table?

 

[Debra Dalgleish]

Select a cell in the Pivot Table
From the PivotTable toolbar, choose PivotTable>Wizard
Click the Back button
Select the range you want to add
Click the Add button, click Finish