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