Excel 2007 : controlling sheet tab names

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!