Timesheet and staff rota templates

Description of excel work: I would like to use Excel to be able to put together a monthly staff rota, then automatically take the hours from that rota and put them into a timesheet for individual members of staff. They would then be able to confirm those hours and add other hours/sick time etc on the timesheets as the month progresses.

Finally, I would like to take the total number of hours from each individiual timesheet and put them into a master sheet to set off to our payroll dept each month.
Extra notes: