Sum multiple sheets

[KevinThomas]

Hello all,
I have a excel file, and every week a new sheet is added. All sheets are in the same format, but have different dates as the sheet name (instead of sheet 1, sheet 2, etc).

What i would like to do, is sum a specific cell from each sheet (Q8 for example) in a sheet called total.

I also need this to work if new sheets are added, which i find is my biggest problem

There must be a way to do this, can anyone assist?

[NBVC]

Add a blank sheet before the first called something like: Start

Add a blank sheet after the last called something like: End

Then use

=Sum('Start:End'!Q8)

you can insert anything between the 2 start/end sheets.

[contaminated]

Use Excel 3D reference...

[KevinThomas]

Thanks Both. Magic