Hi again,

Ok - don't worry - I've met enough "technophobes" to know what you're talking about!

The basic problem then becomes one of detecting missing worksheets.

I'm assuming that under normal circumstances the Agent workbooks remain closed on the server while the Supervisor workbook interrogates them via the workbook links. Would it be acceptable to provide an "Open Agent Workbook" button on each worksheet in the Supervisor workbook? This button would open the associated Agent workbook, check that workbook for missing worksheets, update the formulas in the Supervisor workbook accordingly, and then close the Agent workbook.

How does the above sound?

Regards,

Greg M