I have tried modifying the VBA code using several of the previous
suggestions but it does not change.

I am trying to link a worksheets "TAB" name to a particular cell in a
pre-existing file.

Question?
Does the sheet need to be named as a default "Sheet1"?