Excel 2007 : controlling sheet tab names

I need to link 15 sheets (tap names) to 15 different cells on a master sheet. The cells will be used to add team members names that will then automatically rename the sheet tap to match the new name. Each of the 15 sheets have different function and formulas so copying and adding new sheets will not work. I need the 15 sheets to remain unchanged except for the sheet tab name.

Now i was able to add a code in the master sheet that change the tab name of the master sheet but don't now how to edit the code to be able to do this to all 15 sheets from the one master sheet.

please help

Can any one help me with this or is some working on a similar problem

Hi,
I'm not exactly sure if there is a way you can do that but I have something that might help you. There is a way to display all the sheet(tab) names on the master sheet, but to change the name of the tabs you have to right click the tab you want to change, and select rename. Once you rename the tab, the name will be updated and displayed on the master sheet. So it sounds like what you want, but you have to change the tab name on the actual tab instead of the master sheet. Here is how you do this:

This is assuming you want to list the tab names in column A starting in cell A1

Click on cell A1>Go to Insert>Name>Define

A dialog box should appear if my memory serves me correct. Type the following in that box:

Name: SheetNames
Refers to: =GET.WORKBOOK(1)&T(NOW())

After that, enter this formula in cell A1:

=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))

the current sheet you are on should now be displayed in cell A1. Now click the bottom right corner of cell A1 and drag it down until you get a #REF! All sheet names should now be displayed and you can delete all the #REF!

Let me know if you would like a sample workbook.
Hope that helps!

Now i was able to add a code in the master sheet that change the tab name of the master sheet but don't now how to edit the code to be able to do this to all 15 sheets from the one master sheet.

What was that formula? - perhaps you could put that formula in each sheet - with it referring back to your list on the Master Sheet.