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?