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