How am i able to populate a sumation for multiple sheets

[swiftcode]

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

[Anne Troy]

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

"swiftcode" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[swiftcode]

Hi Anne,

Thank you very much, this is very helpful.

Have a good week.

"Anne Troy" wrote:

> Try this, Ray:
> http://www.officearticles.com/excel/...worksheets.htm
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "swiftcode" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>