Is this functionality possible in Google Sheets?

Question

Google Sheets

welcome all!

the task is to process a certain amount of data by several employees.
how I imagine it:
1. All the necessary volume is entered in one sheet / table
2. The responsible person is affixed for each line of data
3. Each responsible person has his own sheet, where he sees his "front of work"
4. The responsible person works with information. Enters a comment, ticks what he did (in the line), etc.
5. I see all these changes on the main sheet, and plus I have statistics on executions.

If this is possible, maybe there is an implementation example somewhere?

Answer 1

You organize the differentiation of access rights to data for writing through additional documents, i.e. 1 document per user and then scripted central document collects data from all documents