Is it possible to in VBA to look through a number of Workbooks and
open a workbook to the sheet containing todays date in a particular
cell?

(e.g., Workbook names: DTS-351-Jan, DTS-351-Feb, etc...
Each workbook contains Worksheets named 1,2,3,4,etc... Where Worksheet
names represent the DAY of the month (based on a 5-4-4 Weeks model)
and where the DATE is in the same cell on each sheet. )

Can VBA find Todays date in those workbooks and open the workbook and
worksheet with Todays date in that cell?

Sorry this is not asked very well. Hopefully you can understand what
I'm asking.

Dave