I don’t think that is possible. As far as I know, Excel does not support any concurrency, so data would be constantly overriden if more than one person was allowed in the same sheet at the same time. Every save would overwrite the other’s work.
Perhaps a database would be a better place to store the data that’s in these spreadsheets. Even a MS Access database has support for multiple connections.