That actually poses a potential answer. There's a good chance of the agent workbook actually be opened when it's being assessed by the supervisor workbook, but at the same time if I could put a link or button within the supervisor workbook that opens the agent workbook, the server issue it out as read only which would be fine for the situation.

So I guess the next question then would be, how can I have the supervisor workbook assess missing sheets and update the formulas?