title: Excel VBA - link rows from different sheets
body: <p>Scenario: I can't post the actual workbook due to sensitive materials but I'll explain it as best as possible.</p>
  
  <p>Each Sheet is divided into branches i.e.: Sheet2 is Branch 2, Sheet3 is Branch 3 and so on.
  For each sheet the column are the same.
  Column A has the branch number in it.
  Column B has irrelevant information so i just hide that column.
  Column C has a system number (specific to each account.</p>
  
  <p>Intention: I want to create another sheet called <code>CallOuts</code>.
  I want to copy some rows (from various branches) and paste them onto the 'Master sheet' (<code>CallOuts</code>) I can work on the <code>CallOuts</code> sheet instead of going to each branch. So that whenever I edit a cell it will also update/change that exact same cell in the branch sheet and vise versa with the master sheet.</p>
  
  <p>Problem: I know MS Exccel has a "Paste Special" function where it adds the cell. The problem with that is it links the cell# so if I sort the Master sheet it will replace the row into the wrong branch sheet.</p>
  
  <p>E.g.: If System# J112 is in branch 2 sheet, row 2 and I have the link pasted in Row 4 in the master sheet, if I make updates on the Master sheet and then re-sort it and the System# now moves to Row 2 (on the master sheet) whatever is in Row 4(on the master) will now be in Row 2, Branch 2 sheet.</p>
  
  <p>I was thinking maybe a macro where I could copy and paste the entire row from the master sheet. Do some type of case selection to check which branch is in column A and then find the same system # on the branch sheet then paste the whole row.</p>
  
  <p>My VBA level is novice at best so any help would be appreciated.</p>