Time Sheet and Project hours analysis - urgent!!

Hi All,

I am a basic user of excel. I have setup a monthly time sheet for myself. Where i can tabulate hours against projects. I have also allowed for a drop down for the projects. However i would want all the hours i spend on my projects during different days in a week to be tabulated against that particular project on the project record list. This is important as i need to know how i am tracking. I could do it manually but it will be very tiresome so was wondering if someone could help me arrive at a formula/function. Please find attached my sample time sheet. Look forward to a quick response. Many Thanks in advance. Monika