=Sheet2!A1

or are you meaning something more complex?

--
HTH

Bob Phillips

"Irene" wrote in message
...
How do you bring totals from one worksheet to another.