Need assistance with quering remote workbook

Hi again,

Thanks for your last post.

Quick question - does the Supervisor workbook contain one worksheet for each agent?

More questions - does each Agent worksheet correspond to a single month? If so, does that mean that there is a theoretical maximum of 31 worksheets in an Agent workbook and 31 rows for each agent in the Supervisor workbook? Are agent worksheets always named sequentially starting from "1"?

The answers to these questions will help me to decide how best to check for worksheets missing from the Agent workbooks.

Regards,

Greg M