I am trying to create a summary page that will display a month's data for
various rows. I have multiple sheets.

Example of what I want it to do:

Search sheet1-sheet6 for January 1
If found, record data in column B

Search sheet1-sheet6 for January 2
If found, record data in column c

and so forth. There are about 50 rows of information that I want to copy
from each sheet and the dates are in B2-H2 in each sheet.

Thanks for the help.