I would like to have several workbooks linked to the master workbook, however, I do not want the people who will be accessing their respective sheets to see what is on anyone else's sheet, nor the master.

So I am wanting to pull specific rows of data from a sheet on one workbook to another sheet on another workbook based on multiple values in one column (the sheet contains some conditional formatting and several columns contain formulas). However, I want the secondary workbook to have the ability to be revised and update the master sheet upon revision, as well as if there are any revisions to the master to automatically update the secondary. Is this something that is even possible?

The formula I have currently will pull the data, however, if any information is revised on the secondary sheet, the formula stops working.

=QUERY(IMPORTRANGE("key","Sheet 1!A:AE"),"SELECT * WHERE Col5='Program Name'")