How do I combine data from 4 worksheets?
 

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.

How do I combine data from 4 worksheets?
 

This will add the A1 cells in 4 sheets
=SUM(Sheet2:Sheet5!A1)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"grndmntjd" wrote in message
...
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.