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.