looking for a date and returning associated data

[ezzy85]

I have a workbook with a separate worksheet for each person. Each person has monthly data. I want to be able to input a date and then go through each worksheet and return the data in column D (see attachment) for each person for the specified date and put the results in a table in a new worksheet.

I have attached what Im talking about.

I tried creating a loop to go through each worksheet but I cant work out how to search for a specific string in VBA.

Thanks