Drop Down Menu & Sum

[Ray_n_yellow]

I have a book that has a drop down menu of a list of people. I would like to click where it says date and it makes the windows clock pop-up so I can click on a date and it puts the date in for me. I would also like to put the amount of cash they paid and it will make a chart on sheet 3 and keep adding to that toal each week that I update it. I have attached the file for futher help. Thanks