search multiple sheets for specific date, return data in cell to r
 

Greetings all,

I'm trying to build a formula (maybe only a macro can do this?) that will:

1. search through several worksheets in a workbook for a variable date that
I assign each time I run it

2. return the dollar amount figure in the cell to the right of each date
that matches my parameters

3. add all these dollar amounts together in a cell on a summary worksheet

Thanks in advance for any suggestions!
Pat :)