How do I create an automatically expanding data table?

[johnw993]

I am creating Weekly time-sheet forms for employees. Each employee will enter hours daily for approx. 30 categories of different tasks. I want for the totals of each completed timesheet to be added as a new row (with start date of week, employee name, department, hours by category, etc.) to a self-expanding data table (database?). Meaning, if the employee uses the same time sheet form for a new week to enter new hours, the data from the previous week that was added to the data table will not change, but the new data entered will be added as a new row.
I'm not concerned about the order or sequence in which the data will be added to the data table. I'll use pivot tables to extract reports for each individual employee by task, day, week or month.
With 40+ employees and anywhere from 10 to 30 different tasks each per week, I expect to end up with approx. 70,000 rows of data. Too much to save each individual timesheet.

[davesexcel]

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[johnw993]

Thanks Dave, that was very helpful.This group is great. So responsive.