Here's a start. Put the code into a general module in excalations.xls and make sure that the workbook sec sample.xls is open.
There's a heap missing.
1) How do you want to check for the date? Have an input box that will ask for the relevant date? If you do this, then you have the option to check a range of dates rather that being restricted to only being able to run for a specific date based on the day of running.
2) What is the full list of workbooks being actioned? If you have the list, and they are in a particular place, then you could loop through the list, opening and closing as each is actioned.
3) I've used the sample as a reference for "Nothing found". If there is something else to check on please advise.
4) What about the other sheets in the workbook? Do they have any action or is it only sheets 1,2 and 3 that are being checked?