title: VBA - Insert Formula referencing other sheet
body: <p>I have a workbook with two sheets. In sheet A few cells have to change if data in few cells of Sheet B changes.</p>
  
  <p>For example Sheet B Cell A1 is changed then same has to be reflected for Sheet A Cell A1.</p>
  
  <p>I was thinking of just inserting a formula like <code>=Sheet B!A1</code> in A1 of Sheet A. Can you guys help me solve this problem? Any other approaches are more than welcome.</p>
  
  <p>Thanks in advance.</p>