info/data transferred/copied from worksheet to worksheet in same workbook!

Hi All,

I need info/data from "Weekly Time Sheet" worksheet to be transferred/copied over to "Project Tracking" worksheet in the same workbook.

as follows:

1. project number copied to the project number column.
2. total "R" hours for same project number copied to "R" hours column.
3. total "O" hours for same project number copied to "O" hours column.
4. employee name for same project number copied to "Employee" column.
5. time sheet ending date for same project number copied to "Week Ending" column

then have the "Weekly Time Sheet" worksheet cleared of contents, But only have from "A14" and below cleared and removed for next employee to enter his/her time.

Have I've attached my workbook, please see below.

Thanks in advance
Joe.