Link Worksheet Tab

swelch,
I just finished writting and posting some code for your similar question regarding 3 days a week sheet tabs.
The answer to your above question is to use a WorkSheet Event-Macro.
Any change to cell A1 will be reflected in the Sheets Name.
*** Remeber that Sheets Names are limited and do not aloow special characters etc'
-------------------------------------------------------------

Private Sub Worksheet_Change(ByVal Target As Range)
     On Error Resume Next
     ActiveSheet.Name = [A1]
End Sub

Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” Excel MVP – Excel (2009-2018)
ISRAEL