I have created a template that has several identical worksheets in a workbook
with an overall summary sheet that provides a report of the totals from all
worksheets. This is used as an expense system to assign costs to various
clients and provide an overall summary for VAT and employee reimbursement
purposes. Because the client list changes from year to year I have named the
worksheets Client 1, Client 2 etc.

What I want to do is to allow the person administering this sytem to rename
a worksheet and have that name automatically update the "Client name" cell at
the top of the worksheet, and thus be linked through to the summary sheet.
The problem is that I want each worksheet to have its own name - I used the
Microsoft KB to find out how to do this for the active worksheet and this
works fine but I cannot work out how to get this done for each worksheet
individually whether they are active or not.