How to implement Google Forms data collection principle for Google Sheets?

Question

Google Sheets

Hello!
At the moment, I am creating an elementary CRM system in the Google Sheets environment. The bottom line is this. There is a buyer A and a buyer B. For each of them, a separate table file is created, where they leave their order. There is also a collection table (also in a separate file) where all their orders should be collected and processed.
The problem lies in the access settings. By means of Google App Script data exchange between tables is possible. I used the openById method. BUT! This method works if you open access to the prefabricated table for the buyer (which is generally undesirable).
Through QUERY also does not fit, because a "live" table is created.
I know that when you create a Google Form, then all the answers are recorded on a separate sheet and no one has access to this table, except for the creator of the form.
The question is: is it possible to implement this in Google Sheets? only instead of a form there will be several tables of buyers who, on click, will send their orders to the combined table and, most importantly, will not have access to it.
Thank you in advance!

Answer 1

sashka_shishka , carefully read your question "... will send their orders to the prefabricated table and ... will not have access to it ..." and try to deal with the contradictions yourself.
By submitting the Form, the Respondent transfers the right to the Owner to process his data. There is no forced entry of data.
Unfortunately, the general (most) idea of ​​​​accessing the Disk and its files is very different from reality. Your idea is unattainable by regular means of the Disk. It is possible to create a web application based on Google Apps Script, which will "do" this way.
Another option is to invest in GSuite Business and make a form in App Maker.
You've tried IMPORTRANGE by importing data from private Tables into a PivotTable.