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.
--
HTH...

Jim Thomlinson


"Candace" wrote:

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?