Linking worksheets

Hi,

I would like to have a single worksheet that contains
cells from other worksheets in the same workbook. But,
it appears from Help that I am only able to link a single
cell Sheet!A4. Is there a way to have a single worksheet
be a compilation of various cell ranges of other
worksheets in the same workbook?

Thanks,

Ray

=sum(sheet1!:sheet5!a1)
=sum(sheet1!a1+sheet2!a1,etc)

--
Don Guillett
SalesAid Software

"Ray" wrote in message
...
Hi,

I would like to have a single worksheet that contains
cells from other worksheets in the same workbook. But,
it appears from Help that I am only able to link a single
cell Sheet!A4. Is there a way to have a single worksheet
be a compilation of various cell ranges of other
worksheets in the same workbook?

Thanks,

Ray

Thanks for the tip. What if the cells are text? I would
like the master worksheet to be a compilation of text
extracts for other worksheets in the same workbook.

Thanks,

Ray
-----Original Message-----
=sum(sheet1!:sheet5!a1)
=sum(sheet1!a1+sheet2!a1,etc)

--
Don Guillett
SalesAid Software

"Ray" wrote in
message
...
Hi,

I would like to have a single worksheet that contains
cells from other worksheets in the same workbook. But,
it appears from Help that I am only able to link a
single
cell Sheet!A4. Is there a way to have a single
worksheet
be a compilation of various cell ranges of other
worksheets in the same workbook?

Thanks,

Ray


.