Linking worksheets

[Ray]

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

 

[Don Guillett]

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

 

[Guest]

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