Update Master Sheet with multiple source sheets
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.