Thanks guys worked like a charm.

"TNMAN" wrote in message
...
I have a workbook that contains 12 worksheets of identical data/format and
a
13th worksheet I would like to provide totals of the 12 monthly
worksheets.
Is there an easy way to write this sum formula without going to each
worksheet. I am using version 2003. Thanks in aadvance for you help.