Hi Dave, thanks for the reply. I have had a look and it is on it but I still
don't know how to use it. Can you advise please?

"Dave" wrote:

Caroline

I don't know if this is available in the version of Excel you are using but
in Excel 2003 try Consolodate on the Data manu.

Dave
"Caroline7361" wrote in message
...
I would like to know how to create a summary sheet for a workbook, for
example if I create worksheets for 3 branches of a company with the same
headings and formulas, how do I do a total summary sheet for all three
together?