How to make access control in google sheets?

Question

Google Sheets

now there is a system of financial accounting of the enterprise in 10 different tables.
9 of them are accountable persons (accountant, chief engineer, financial director, director, etc.), the
remaining one collects all the data and all calculations are made in it.
further, data is unloaded from it, which accountable persons should see.
in principle, everything is clear in it, but there are difficulties when making changes - they need to be done in each individual table, edit scripts, etc.
can I collect all the tables (books) into one, giving each person access only to those data which does he need? so working with the system will be much easier for me.

Answer 1

No, you cannot restrict access within the same Table.
Use an external script to manage all other Tables - it's easier.

Answer 2

Tools -> Protect sheet.
Well, or right-click on the selected area -> Protect range.
Then choose who can edit.

Answer 3

If the data is only for viewing - you can publish the sheet as a document, moreover, it will not be possible to edit, and there will be no access to the rest of the document.
Файл - Публикация в интренете