Automating Cell Link
I've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When the new project is assigned, the row is copied to the individual's sheet (to whom it was assigned).
Is there a way to automatically link the status and progress cell back to the master sheet so when a change is made to the individual sheet, the master sheet will change as well? I'd like to avoid having the individuals have to manually link cells every time they were assigned something.
I'd even be happy with a replace function where the whole row was copied back to the master and replaces the original row (doesn't look like that exists).
I do have approval automation set up for the status cell I'd just like to link cells as well to cover all bases.