Duplicate row's

Options

Hello, I have consolidated 17 files into one and have created a workflow which ensures that every time a new row is added on these sheets, it will be copied on to the consolidated sheet as well. 

But the downside is that every time a row data is updated on these 17 sheets, it creates a duplicate row in the consolidated sheet, instead of updating the original row data.


Is there a way I can just get the rows updated instead of creating a new one?

Answers