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