How to link cells in different sheets in google spreadsheets?

Question

Google Sheets

Good afternoon, gentlemen, please tell me how to implement the following:
1. There is a google table with a specific customer base and, accordingly, with statuses on their various issues (Why don’t you ask google tables, crm is too cumbersome, it takes a lot of time to drive in one person, and in day work with the base is constant).
2. There are several employees where everyone performs their duties for certain people. That is, processing one person, other issues another person.
The idea was what - 1 sheet the general base of clients with columns of their statuses. (there are about 25 of them)
And each separate sheet for each employee of the same table only according to the statuses with which he is engaged. (because there are a lot of them, and you don't need everything).
What is the problem - when you bind the second sheet to the first one (= sheet1), everything is fine, everything is displayed on the second sheet, but you cannot edit it. And I would like the changes made from sheet2 to be transferred to the main one (sheet1). And also from sheet 3, sheet 4, sheet N. Is this possible, or are there any alternatives to solving this issue?

Answer 1

Yes, this is possible.
You need to use Google Apps Script or another programming language to complete the task. Try to initially think over the solutions so that later you do not get confused in the wilds of half-realized ideas.
Possible ways and some questions:

• Refresh data array periodically / on a schedule
  
• Event data update. For example, the user opened the Table / made changes
  
• Update only part of the data
  
• Data mutation at the time of transfer
  
• Define the role of the user / data manager
  
• Other access / code execution restrictions
  

If you need a specific example or a piece of code, then post additional information according to the rules. For example, how is Google Apps Script for Google Sheets: how to rename ...