Work Flow and Automation help

I am attempting to set up a workflow sheet between operations, sales, and owner.

The idea would be to have master sheet where information is fed to it through multiple sources. Once the master sheet has all of the data needed it would then feed to sales and the owners to give them a snapshot of their work.

Is it possible to create a master where multiple people can work on separate sheets to feed data and keep from multiple hands touching one sheet at the same time.

Is it possible to create an automation that will update rows rather than copy?

Lastly is there way to automate this to update rather than having to manually prompt it to run?

Any help would be great and I'll keep combing through here as well.

Thank you!