Copy to new sheet automation

Good afternoon,

Hopefully, someone can help me with this.

I have multiple smartsheets that copy into a master smartsheet as new rows as added.

The issue I've discovered is if the users of the multiple sheets update row data, which they will regularly, the updates do not transfer across. Equally, if I run the automation manually, the rows which have already been copied across, come across again but with the most up-to-date data.

The master file will be a massive document so spot-checking these issues won't be possible.

Any suggestions of how the master document can always contain the most up-to-date info from the multiple sheets?

Appreciate any suggestions.