PivotTable based on multiple ranges or tables

[Candace]

If I have multiple ranges or tables on one worksheet, can I create a Pivot
Table based off of more than one range or table? For example, if a worksheet
has the following tables/ranges: office1, office2, office3, and each
table/range contains a list of equipment for each of those offices, can I use
create a PivotTable that shows the "telephone" equipment from all three
offices?

 

[Jim Thomlinson]

Step 1 of the pivot table creation wizard has 3 different options for source
data. The third option is Multilple Consolidation Ranges whixh will allow you
to consolidate from multiple sheets. You may want to add the Office number
inot the source ranges on each sheet so that your pivot table can consolidate
by office.

 

[Candace]

Ok - My employer wants to also be able to see all offices and equipment on
one sheet. So would this scenario work:

1. leave the original office equipment on one worksheet in multiple tables
2. create a linked copy of each table on a separate worksheet, so that when
information changes on the consolidated worksheet the changes trickle down to
the tables in the on their individual worksheets
3. create Pivot Tables based on the individual worksheets