consolidate data in pivot table

[vickie s]

I would like to consolidate the data from several worksheets into one pivot
table. All of the worksheets have the same number of columns with the same
column labels but each table has a different number of rows with various
entries in column 1 of each row.
Column 1 contains peoples names and the people involved can change each time
the data is collected. The names may repeat in one worksheet and they may or
may not appear on every worksheet.
Ultimately I would like to create a chart that shows the trend for a person
from month to month.

 

[ShaneDevenshire]

Hi,

There is an option on the first step of the Pivot Table Wizard that allows
you to use multiple ranges for consolidation. You should check this out
first, if it works great. The second option is to copy the data from each
sheet into a master sheet and build the pivot table from that. Its an easy
solution, but it may not be appropriate in you case. The third option is to
use a UNION query to create the cache, this is quite challenging.

But if the other techniques don't meet your need, post back.