I need to set up timesheets for jobs that will be filled in on a daily basis
and the summary of the hours for all the jobs to be reported elsewhere. Given
that quite soon the timesheets will become quite large and the number of jobs
may number up to ten or so at one time with up to ten or so people recording
their hours, I want to know what is the recommended file/worksheet structure
for such a project. Each job may be as short as a week or go for at least 12
months.

For example is it better to have each job in a separate file and then link
the fields into a summary file? Or would a single file with worksheets for
each job be ok?

Thanks