How to auto-update the formula

[seacnlib]

Hi,

I created 5 worksheets and using AVERAGE formula link from the consolidated worksheet. May I know how to auto-update the formula in the consolidated worksheet if I add/copy another worksheet (for example, worksheet "S6" (see attached). The reason is I will pass this file to somebody who do not know how to modify formula.

[royUK]

See the Summary Sheet example here

http://www.excel-it.com/workbook_downloads.htm