How to efficiently link data from one sheet to two other sheets

Options

Hello,

I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working.

  1. Created a form on the Master Sheet.
  2. Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed into a metrics sheet, when I add a new submission on the Master sheet, it goes to the bottom of the sheet at Row 50 even though there are many blank rows above. See screenshots below to understand what I mean.

Goal: I want the gray columns in the Setup tracker to be populated by a form and be inputted into two additional sheets.



Answers