Just type "=" in any cell, click over to the other worksheets and choose the
cell you want.

For example if you want to reference cell A1 in tab "Sheet2" Excel will
create the formula:

=Sheet2!A1

--
Regards,
David Billigmeier


"scottcts" wrote:

I'm having trouble figuring out how to simply take data from multiple
worksheets and list it in one "total" worksheet all within the same workbook.
I want to have this perform automatically as opposed to me using the
copy/paste function and do this manually. All the data will be in the same
layout from page to page. Any help would be appreciated.