linking rows across different sheets
Ok this one seems to be a little more advanced of a question, once a row is copied to another sheet is there a way to link the the copied row to original row so that whatever changes are made to the copy also happen to the original row. lengthy description below with screen clips.
the first screen clip is the master list with a drop down box. when the selection "SDR" is selected the row copies to a different sheet for detailing (2nd screen clip). detailing completes their task and selects "submitted" I am trying figure out how make that selection update on the master list. a similar occurrence will also happen when "release" is selected and the row again copied to a completely different sheet in the production shop and once the job is complete and at the selection of "Invoiced" is selected how to make the original row within the master list update with all added information and attachments.
Thanks in advance and if there is any additional information need please do not hesitate to ask and I will answer to the best of my ability.