Really need some ideas/help on this.

I have an area that will be taking several workbooks (1-50 a day) and needing to work in them at the same time (1-15 users). I have a shared drive for everyone to get to. And all the macros set up, etc.. I am worried about using the share function on excel. Already in testing I am having issues with multiple people saving at the same time.

No one will be changing values in the same sheet at the same time. Everyone will be working in a different sheet in the book.
I understand the potential of putting it in an access database and working from that angle. But everyday it will be different workbooks and this will get very labor intensive.

Anyone have any helpful hints, other alternatives?

thanks.