worksheet name to match name in cells

[Pete]

See attached file
Hi Experts

How would you do the following. Current i have the first worksheet name in the workbook as "R_Share_Phase_1_Countries". I want this name to change automatically if the user change the this name in the worksheet also. i.e

1. User change current worksheet name R_Share_Phase_1_Countries to R_Share_Phase_2 then

2. Also change the name in column B cells B15, B28 and B41 i.e. section highlighted in yellow. With the user having to re-type this name in again and again

[Bob Phillips]

Put this formula in each of the cells

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)