Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies