adding values from a date to a time line.

Hello,

I have a difficult problem . I have attached an example to help me explain what I am trying to do. I have two pages in my workbook. On sheet one I have:
Deposit 1 Date Deposit 2 Date Balance Date
1 Value Day Value Day Value Day
2 " " " " " "
3 " " " " " "

On sheet 2, I have a horizontal calendar :

Jan Feb Mar ect
1 2 3 ....

Each month has a value 1-10, vertically I have:
Deposit 1
Deposit 2
Balance

What needs to happen is in sheet 1, say the deposit for 1 was $4,000 on 2/12/07. Then I would want $4000 put in row "deposit 1" under column "2" for February. However the difficult part is there may be multiple Deposit 1's in Feb. So it needs to be able to combine all Feb deposits into that 1 cell.

Any help would be EXTREMELY helpfull. Thank You in advance.