How to organize the relationship of Google tables?

Question

Google Sheets

Good afternoon!
There is one large summary table in which information is entered for different departments. Each line contains the following information: Text block, Deadline, Status, Comments. This table is updated regularly.
It is necessary to organize a separate table for each department, in which the user will be able to comment and (optionally) put a mark on the current status. This comment must be transferred to the main table.
What I tried: The importrange function to create a copy of the full table and then filterto collect data for a specific department. After that - adding a separate column, from which information is pulled into a sheet with an importrange. This method is working, BUT it is unacceptable to allow the user of a specific department to view the general table.
How can separate files be organized to collect responses from departments?

Answer 1

You can try to invest in the future and use crm