How to create report on sepearte sheet

I am working on a time sheet, and i want to create something that is showing their daily time, if they are hourly or salary, and how many hours they worked on what projects. I want the employee to complete this part, so that when they are done entering and it is time for them to submit their time cards to the finance manager for payroll, the finance manager is able to generate a final report for each employee (on a separate sheet) and get times for what was worked on what projects. I know this is doable. but how? can someone help me plzzz!!!

Please attach a sample workbook of your time-sheet so we can help you further. Also, provide the output that you desire which has to be sent to the finance manager.