Martin,

two files attached. MD master is the file which collates the data from the timesheets. TS1 is a timesheet. Note I have amended the timesheet format slightly so this will need to become your new template timesheet (see notes).
I recommend you error check for mathematical errors before deploying.
The master workbook also has a populateallrnd macro which will populate all timesheet workbooks within a folder with random numbers.
Any probs/questions email me at andrewlitchfield@gmail.com for fine tweaking