Thanks Bernard....I tried this and got an error....#NAME?
What did I do wrong?

"Bernard Liengme" wrote:

=Sheet1A1 in any cell of Sheet2 will display the value in A1 of Sheet1
If sheet names have spaces in them you need ='October Sales'!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ladytar" wrote in message
...
I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet.
How
can I accomplish this?

Thanks for any help you can give.