Please...I'd like advice on the most straightforward way of tackling an
upcoming project. I am someone who is pretty good with excel formulas and
functionality, but don't know VBA or programming. Here's the situation:

Regular reports need to be run on various training data. Data is needed
from 30 different trainers who will be providing this data at the end of each
week.
This file or files will reside on a shared drive.

Options:
1) Do I create a masterfile, and manually create (hundreds of) links to 30
input files, one per trainer?

2) Do I create 30 trainer files, and then do some type of file merge each
week?

3)Do I create ONE big file with twelve month tabs, that everyone keeps
adding to?

Concerns:

Option 1- I don't have access to that shared drive - I'll have to be
creating the work and sending it by email. Would the links still work? This
is also very laborious.

Option 2- A bit cleaner. Can I merge 30 different files if they're all
formatted in the same way? Could a macro be written that will do this merge
in the same way every time? Could the "merge into" file have some extra tabs
where the reports would reside?

Option 3 - The simplest of all. But - I'm afraid of what will happen if more
than one person is inputting at the same time. What will happen if two
people are trying to enter something on to the same next blank row?!

Thank You SO much!!!!!