Linked Documents or appending Docs in Sharepoint Solution Needed

Hi
I have a central excel document used for contracting music shows stored in SharePoint that myself and 4 other people regular use, we are running into problems with several people wanting to use the document at the same time and getting a read only alert, thus delaying them
Co-authoring on SharePoint online is possible, but it’s too slow, has reduced functionality and loses formatting so isn’t suitable.
I am trying to think of ways to reduce the need for people to be in the contracting document at the same time, sometimes they will want to add a full new show (row) but other times they want to just check certain info
All four people work remotely not on the same server
I was wondering if it were possible to have separate linked documents on SharePoint that could be accessed locally? The master document would be used to add new shows, the other two documents would update from the master.
I’ve attached an example if you assume each of the tabs are a separate stand-alone document
Doc 1 (Full Contract) columns A – AM
Doc 2 (Deal) contains columns A-G and H – R from Doc 1
Doc 3 (Com) contains columns A-G and AJ – AM from Doc 1
The above documents are hypothetical – if a solution is possible I could do with understanding the process so that I can apply it to the correct documents
Alternatively could each person have their own full document which would update a master, someone previously has kindly created append documents using macros for me but I couldn’t get them to work on SharePoint – they said the problem was to do with SharePoint permissions but I checked this several times with Microsoft who confirmed all permission were in place and that they felt the document were corrupt. I have also attached these documents
I am open to any other suggestions of how to approach the problem if any has any suggestions

Thanks in advance

Dave