Automatically naming and renaming tabs based on changing cell values

Hi there, I'm pretty new so apologies if my etiquette isn't quite correct. I have a spreadsheet (Sheet 2) where a cell (A2) is filled by selecting a name from a drop-down menu, e.g. Glasgow and East Dunbartonshire. When this value is returned the spreadsheet will lookup a table and identify a range of services located in that area, e.g. Herries, Dalmarnock, Coltpark. I have up to 50 services and need to use a specific template across all 50 so I have copied/pasted the template accordingly. Each spreadhseet will be autopopulated with the service name from the lookup table in Sheet 4 (E1) and I'd like to be able to automatically name the tab with the same name. When I've been thinking about it, I will want to make several worksbooks to cover different areas and so I'm looking for a way to either restore tabs to default (Sheet 1, Sheet 2, etc) or to be renamed without crashing as each area has one name that is the same to them all "New Work". I hope this makes sense.

Screenshot 2021-09-29 174444.png

Any help gratefully received. Best Wishes, Rob.

To get you started, possibly...

Please Login or Register  to view this content.

If not, post a sample workbook (not images) as explained in the yellow banner at the top of this thread.