excell formula

[hargi]

Is this possible? I have a spreadsheet with lots of worksheets in now i need to create a new worksheet that summarises all that data.
The work sheets are named after places
I want to do a formula thats psedo coded like
= ('avon'!G24+'Birmingham'!G24 ect / 30) is there a quick way of doing this with out having to type all the names in or clicking each sheet?

 

[GravyMonster]

Afraid not, you have to type in the names of each sheet, or click on the cell itself to have excel put in the reference for you - but that's likely to be more time consuming.

 

[Meeko]

Assuming you will be adding your summary sheet as the first sheet (left most tab of your worksheet tabs), you could use the following formula :

=Sum(Sheet2:SheetX!G24)/30

Where Sheet2 is the name of the second worksheet (e.g. Avon) in your workbook and SheetX with the last worksheet name (e.g Zanzibar).

 

[hargi]

Thanks