Excel "GetData" from file or web (OneDrive)

Hello! 

I am trying to import data from a shared file via OneDrive (into another shared file via OneDrive).

I have tried two different options:

1) Using "GetData" from a file. This works if I am using my computer. The moment I use another computer with access to the same Drive, I have to re-link the data from the new computer to the same file. I even changed the names of the multiple computers to the same name, so they have the same "filepath". It is still not working (without re-linking the same workbook when on a different computer).

2) Using "GetData" from a excel link on OneDrive. I tried multiple links, the one that seems to work is "downloading" the file, and copying the download link. This only works until the file is changed and a new link makes the old download link obsolete.

Please advise on how I can use either methods to link the data, without having to update the links (or files) every time the sheet is opened from another computer, etc.

Thank you so much! I have spent countless hours trying to resolve this issue 😞