Formula For Sum By Date Involving Multiple Cells

[needleme]

I'm a simple office worker trying to put together a spreadsheet and got a question.

I would like to enter a date on Cell #1 and upon entering the date, I would like the currency figure in Cell #2 of the same worksheet to be added to a "sum total" in Cell #3 of a different worksheet.

Is that a complicated feat?

Thanks.