Formula for Reading A Non-Existent Reference
 

Is it possible? I have a workbook with worksheets set up for each week of
the year. Each worksheet refers to a workbook from a weekly report I receive
from another department. The problem lies in that the received report does
not have pre-established worksheets for the year (as mine does)...it only
includes worksheets with data from the current and previous weeks. What
makes it harder to reference is that the report's worksheets are titled "2-24
to 3-2" (identifying that particular week), etc. Suggestions?

Paul