Consolidating Data returned from a Table / Form

What format is sent to the team? That is, are they sent the entire list of projects and they only fill in those lines that pertain to them? Can they add items to the table?

I'll proceed with the assumption that the team gets the full lists and fills in those lines that pertain to them.

One possible way to manage the system is to establish a "database" where the data is reported to. This will be an Excel file with a specific name in a specific directory. The team needs access to the directory. When a team member fills out the table and wishes to submit it, there will be a button to do this. This action will fill out a cell on a hidden sheet. An on close event will check for this cell and if it is not set, will remind the user to submit the changes. Also when opening the file, if the cell is set then the user gets a warning that the data was already summitted.

The submission process is merely appending the non-blank rows to the database file. This file can then be used as a data source for your reporting. It may be nothing more than opening it and sorting on task number.

The VB coding to do this is fairly straightforward.