Try this, Ray:
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"swiftcode" wrote in message
...
HI all,

I have multiple sheets with data like that below, my question is, is there
a
simple way to to sum all the figures in the different sheets into
consolidated 1 sheet, with the formating remainin the same, without having
to
do it cell by cell using the "+" or "=" to link them.

Centre JAN FEB MAR APR MAY JUN JUL
0306 1 1 1 1
0
1 1
0307 0 1 0 2
2
2 2
0308 1 1 1 0
1
0 0

Thanks in advance
Ray