If I understand what you want correctly, you can do that by using the
Edit/Find option in Excel's menu bar. Click Edit/Find, click the Options
button so you can see all the possible selection options available, select
Workbook from the Within field and type your date into the "Find what:"
field, then click the "Find All" button. In the list that appears, click on
each different Sheet (only once per sheet is required) and press Ctrl+A.
Once you have done that (once) for each sheet, click Close. All cells
containing the date you searched for will be highlighted on each sheet.

Rick