Can a cell value name a tab?

[RodneyW]

I have about 150 files each is almost identical with a few naming convention changes. It will streamline my work process if I can enter a value in a cell and have it name the tab at the bottom of the sheet. This way, I only need to enter the value in one cell for each file and it will take care of the rest. Is this possible and if so, how?

Thanks in advance,

 

[alansidman]

https://www.mrexcel.com/forum/excel-questions/420441-auto-name-tab-based-cell.html

 

[AlanY]

and this

https://excelribbon.tips.net/T013463_Creating_Worksheets_from_a_List_of_Names.html

 

[RodneyW]

Thanks guys, appreciate the help