Average over multiple worksheets

[drivinatwork]

Looking to get the average of a single cell over multiple worksheets, but I need it to always go to the last worksheet as I will be adding more sheets.

[FONT=&quot]=AVERAGE(Sheet1:????!A1)[/FONT]

Thanks

 

[StephenCrump]

Why not put a blank sheet at the end of the workbook, and insert your new worksheets in front of this.

Then you can use =AVERAGE(Sheet1:LastSheet!A1)