Demoss,

Unless there's a compelling reason to have the weeks in different
worksheets, you will probably fare much better now, and for future
requirements by putting all the stuff in one worksheet.  You're saying "no,
no" right now.  Read "Data across multiple worksheets" at
www.smokeylake.com/excel/excel_truths.htm.

If you do this, you can use simple VLOOKUPs to get the row of the desired
date, or if there are multiple matches, use Autofilter or Advanced filter.
On rereading, I see the latter is your case.

If you're not willing to consolidate the sheets, you'll need a macro written
to weed through the sheets, I'm pretty sure.  Excel has little in tools for
working with multiple sheets, and normal database design precludes such
separate tables of similar data anyway.
--
Earl Kiosterud
www.smokeylake.com