3 base files with confidential infos in a combine master file
I have 3 different sheets. Each sheet if filled out by a factory and I would like to summerize the content of this 3 sheets in a master file. The factories are not allowed to see the content of the other sheets (A,B,C, Master) only their own sheet.
The master file is shared with other people than the base flles (A;B;C). It's not a problem if these people could see the base files but it's not a must.
What is the best way to build it?