Update Master Sheet with multiple source sheets

Tshelton

I am trying to figure out a way to update my master sheet with information from multiple source sheets. For example, I have 10 departments. Each of those departments has their own employee information sheet. I need the master sheet to update not only as rows are added, but also update those rows as information in the columns change (example, start and end dates). I had tried the copy row as rows are added or changed automation, but found that as information was updated within in a row, it copied the entire row creating multiple duplicates within the master sheet. I need to be able to add the rows for new employees, but to also update the information as it changes on the department sheets. Any assistance is greatly appreciated.

Andrée Starå

Hi @Tshelton

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the destination sheets, it will reflect on the source sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!