Linking workbooks across multiple operating systems

Smitty Smith Do users still work off the same "local" copy when collaborating?

I guess it's a bit easier for me to explain with a diagram and steps to recreate the issue:

User 1 updates Actual Revenues

User 1 updates Revenue Report

User 2 updates Actual Labor

User 2 updates Revenue Report

The current issue is that when User 2 (or any beyond User 1) tries to update the Revenue Report file, all of the links are using the addresses of the files on User 1's computer. Is there a way for the files to be set up or linked in a way that users don't constantly need to change the source to point to the copies on their local machines?

Doing research, I see G Suite allows for the use of the https://www.blog.google/products/g-suite/g-suite-pro-tips-how-sync-one-spreadsheet-another-google-sheets/ function which allows the links to be static to a URL. I see that Microsoft is https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/10366332-links-between-spreadsheets-in-excel-online. However, I'm wondering if there is a workaround in the meantime.

I haven't seen much regarding Collaborating in OneDrive beyond working on the same file simultaneously (as that's the primary goal of the feature). Is it powerful enough/set up to handle this as well? What files would need to be set to collaborate, and would there be a specific user in mind that would need to do this (i.e. the business owner "sharing" the file with managers)?

Thanks so much for your help.