Best way to automatically copy and update rows from multiple sheets to master sheet

Hi all,

I have 10 sheets owned by different people who enter rows of information. Each row on each sheet has a unique code.

I'm trying to do the below actions:

  1. Copy the rows from the 10 sheets automatically to a master sheet.
  2. Order them by the unique row code
  3. Enable each owner to update any cell in any row of their own sheet, which will then automatically update the corresponding row in the master sheet (I don't want a second "same" row to be copied to the master sheet). Every cell in the row can be changed except the unique row code (as a reference point).

Can anyone help me establish the right workflow and formula to enable the above 3 actions?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!