Thank you Bob and Arvi for the ideas that may come useful along the way.
Each user is assigned specific rows to work on month on month. Rows may be inserted as needed by a user. The works of each user are extracted through power query.

We finally tested working together in a shared workbook with the dataset in an Excel table and found out that yes, simultaneous and real time editing or co-authoring is possible in tables.