Hyperlink Cell name / sheet name - to change automatically

Dear All

I have a list of team members on Summary sheet and they are all listed from columns G5 to G31. They are all been hyperlinked to their own individual sheets showing their data. Issue is I have a few employees listed as Employee A, B, d etc and we change them to actual name when we need them. So only option is to change the sheet name and then change exactly in Column G cells. So for example if a new employee Dolly starts, if in G27, its employee Z, then i need to change Sheet employee Z to Dolly, and then change G27 to Dolly as well. I will still get error "reference invalid", but ateast the hyper link works. Is there a way to automate it, ie change the cell value and it automatically changes the hyperlinked sheet name as well?

Regards and Thanks.

Thanks, How to do it with VBA? Kindly help

Thanks, How to do it with VBA? Kindly help

Apologies my friend, what happened is my little daughter unplugged the Ethernet cable and the connection was coming back on. So had to press enter a few times to get the message across here. Sorry didnt mean to press the panic button; )

Apologies humdingaling, I was on bereavement leave off late and couldn't respond in time.

I've attached a sample of what I m trying to achieve. As on summary sheet. If i change Cell F8,F9 or F10 to a particular Name, lets say Andy, the corresponding sheet name should also automatically change to Andy. At present what i am doing is changing sheet name and then copy paste the same into the corresponding cell on summary sheet.

Hope I've explained well. Please advise when you get a chance.

Thanks and Kind regards

Thanks so much, apologies for the massive delay