Are all the spreadsheets separate files? Combining the spreadsheets into one with multiple tabs and cleaning up your queries would be a simple way to start making incremental improvements. Can the organization host on Sharepoint/One Drive to facilitate sharing between multiple users?
I'm not...