Create Summary List Page
 

I have a workbook with multiple worksheets. I want to combine all the data
from all worksheets into a summary work sheet. I would like this summary
sheet to update whenever I make additions to the individual worksheets.

I have a worksheet titled "Introduction" that I don't want to be a part of
the compilation. The worksheets that I want to combine named a,b,c.....z.
These sheets contain alpha data only.

Thanks in advance.
c

Create Summary List Page
 

And what kind of summary do you want to do????????

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CB" wrote:

I have a workbook with multiple worksheets. I want to combine all the data
from all worksheets into a summary work sheet. I would like this summary
sheet to update whenever I make additions to the individual worksheets.

I have a worksheet titled "Introduction" that I don't want to be a part of
the compilation. The worksheets that I want to combine named a,b,c.....z.
These sheets contain alpha data only.

Thanks in advance.
c

Create Summary List Page
 

I want to take all data from sheets a thru z and put the data in one worksheet.

"Dave F" wrote:

And what kind of summary do you want to do????????

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CB" wrote:

I have a workbook with multiple worksheets. I want to combine all the data
from all worksheets into a summary work sheet. I would like this summary
sheet to update whenever I make additions to the individual worksheets.

I have a worksheet titled "Introduction" that I don't want to be a part of
the compilation. The worksheets that I want to combine named a,b,c.....z.
These sheets contain alpha data only.

Thanks in advance.
c

Create Summary List Page
 

References to other worksheets look like the following: =Sheet2!B3

Etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CB" wrote:

I want to take all data from sheets a thru z and put the data in one worksheet.

"Dave F" wrote:

And what kind of summary do you want to do????????

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CB" wrote:

I have a workbook with multiple worksheets. I want to combine all the data
from all worksheets into a summary work sheet. I would like this summary
sheet to update whenever I make additions to the individual worksheets.

I have a worksheet titled "Introduction" that I don't want to be a part of
the compilation. The worksheets that I want to combine named a,b,c.....z.
These sheets contain alpha data only.

Thanks in advance.
c