Need VBA formula that will link to same worksheet even if sheet name changes

You could try using the code name for the sheet e.g. Sheet1. This is the value that appears in the top left hand pane of the VBA editor.