title: Copy sheet while updating the cell formula references
body: <p>I have 5 sheets in a workbook. When I "manually" copy 2 of them (in the same workbook), the references (in the cell formulas) are changed automatically for the new copied sheets.
  For example in some cell I have the following formula:</p>
  
  <pre><code>=IF('1_Result'!B5="";NA();'1_Result'!B5*$C$3)
  </code></pre>
  
  <p>And after I copy the new sheets, the formulas in the new sheets changes to:</p>
  
  <pre><code>=IF('1_Result (2)'!B5="";NA();'1_Result (2)'!B5*$C$3)
  </code></pre>
  
  <p>Where "1_Result" is the original sheet and "1_Result (2)" is the copied sheet.
  When I do the copying with the following code:</p>
  
  <pre><code>t1.Copy After:=Sheets(Sheets.Count)
  Sheets(Sheets.Count).Name = nshn &amp; "_Table"
  </code></pre>
  
  <p>...the formulas in the copied sheet don't change the references, so it stays the same like:</p>
  
  <pre><code>=IF('1_Result'!B5="";NA();'1_Result'!B5*$C$3)
  </code></pre>
  
  <p>How should I modify the code, so that the references are changed?</p>