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.

Devin,

Do you need your summary page to list each entry separately (all 50 rows
from each sheet), or can you use a sumtotal of each date from each page?
Also, what length is the longest sheet? (How many rows?)

"Devin" wrote:

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.