I have a workbook with 12 sheets in it. Each one has identical columns, but
the data varies each month. I create a pivot table each month to shows
totals. I create a chart for each quarter with these totals. Because the
totals vary each month, I have to manually enter the totals into another
worksheet and use that to create the chart. Is there a way to combine the
data from four sheets into one to use for a chart? I have tried combining,
consolidation, pivot tables, merging, etc and none of them seem to work.
Obviously I am not understanding how to do this. I really want this to do
fairly easy as I am not the only looking at the data.