Collecting Data From Multiple Users

[MINCUS1308]

I'm sure this is way easier than how I am trying to do this...

I have a file that is acting as a data input workbook.
This workbook needs to be opened by multiple users at once.
The workbook validates the data before sending the data to a separate 'Master' workbook.

How can I set this system up so that multiple users can submit data to the 'Master' simultaneously without running into the "file is already in use" issue?

I appreciate any help I can get,
Thanks

[SamT]

The "Master Workbook" needs to be a database, preferably not MS Access.

You can use a client workbook to retrieve Data from the database as needed.

We would really need to know about the work flow and data flow of your enterprise to give better answers.

[anish.ms]

I have done this recently for my team to track their daily activities using a userform for data entry and database in excel stored in OneDrive. Userform will finally go as an add-in in each user's excel. I have copied here the link to that thread, may be useful for you http://www.vbaexpress.com/forum/showthread.php?68682-Not-Working-Worksheet_Change-Event
(http://www.vbaexpress.com/forum/showthread.php?68682-Not-Working-Worksheet_Change-Event)I would also be interested in hearing other ways of doing it.