Copy & Paste Row 3 from multiple worksheets to summary sheet if cell A3 equals a date

Try this:

Please Login or Register  to view this content.

It produces the same result. Perhaps an example will help. I created a workbook, on a much smaller scale, than the food bank to work on a code. The following is the result of running the code. The dates under "Received" are the last dates that the corresponding households received a food box. For the December results I would like to get only the rows dated 12/17/2014.

Received Emergency New? Last First Adult Child
12/17/2014 Yes Dusty Bit 1 0
10/22/2014 Princess Royal 2 1
12/17/2014 12/17/2014 Wise M 2 1
11/23/2014 Em T 1 2
12/17/2014 Yes Fortunate Lee 1 3

Submit your example workbook

Thanks for taking a look.

So you want specific dates, not just any date? Your original post contradicts what you are now saying. I'm confused as to what you are trying to do.

Sorry, I thought when I wrote, "summary report every month and for just that month" it was letting you know that it was a moving target. I can see where you saw, "how to filter for a date" and thought it was a date in general. I believe I figured out an alternative solution, to simply query by a month. I do appreciate the time you took to try to help.