Search multiple sheets and return list of multiple results

[Abuck]

I have a workbook with 156 sheets.
It is a list of shelf life products with dates that they need to be tested. I want to search for a specific date throughout the sheets and return a list of all products that need to be tested on that date.

The dates are in column c and the product name i want to be returned is in column A.

Thanks for the help.

[davesexcel]

Attach a sample workbook, with maybe just 3 or 4 sheets, that is all that is required to get the proper code to work.

[Abuck]

I have the worksheet at work so I can post a few pages when I get to work tomorrow.
Thanks.

[Abuck]

From the sheets I have here, when you search for 3/3/2014 it would need to pull:
Vitamin 4
Vitamin 6
Vitamin 7
Vitamin 11
Vitamin 14
Vitamin 17

Thank you for the help.