title: Link Excel worksheets to each other so that changes in one are mapped to the other
body: <p>So I have a stock portfolio that I have subdivided into three thematic categories.  Every month I update  each of these categories to reflect new positions added by copying the sheets from the previous months, and manually adding all the new positions and the corresponding information.  </p>
  
  <p>The problem is that when I add positions to one sheet, I add a row and insert new information about that position (price, date purchased, etc.).   This obviously shifts all the cells down one, so that the other thematic sheets no longer have the same row number for the corresponding stock ticker as the newly updated sheet.  As a result, I have to manually add rows in the same position to each thematic sheet in order to preserve row number continuity.  </p>
  
  <p>Is there a way to somehow link sheets, so that adding a row in one area, adds a row in a corresponding area in the other two sheets, along with corresponding column information?  </p>