title: Dynamically renaming excel sheets
body: <p>From a previous question, to dynamically rename a sheet based on a cell reference changing, you use this:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Address(False, False) = "C3" Then ActiveSheet.name = 
  ActiveSheet.Range("C3")
  End Sub
  </code></pre>
  
  <p>But this does not work if the cell ("C3") is in sheet 1 but is itself referencing a cell on another sheet - let's say C3 is referencing "A1" in "sheet 2".</p>
  
  <p>How can you change the code so when you edit A1 in sheet 2, the name of sheet 1 automatically updates?</p>
  
  <p>Thanks!</p>