Populating a sheet from multiple sheets

Okay so here's the situation... I have a daily timesheet for each supervisor that I fill in according to what area the employees worked. I also have to present this information in a weekly database. What I'm tryiing to do is fill the employee name, the Code ID, the quantity, and the hours per person per Code ID. An employee can work on multiple Codes per day. I color coded the data spots on "Ash Monday" tab and "5-1-11" tab to make it easier to see and the data on the "5-1-11" tab is information I entered to show what I need it to do. HELP HELP HELP!!!! LOL


Thanks!!!

Bill