Dynamically fetch print area from other workbook on company network

Hi! Thanks for answering.
I have used Get Data>From File>From Excel Workbook, and then essentially also tried the same thing with a Power Query. 

I see in the connection information that the source document specified is actually the path to the onedrive location on my harddrive, so I understand now why I have to open SOURCE after my colleagues edit it in order for edits to propagate to DEST.

Ideally I would need a path to SOURCE as it lives in the owner's OneDrive cloud location. The owner is a fictive user and has shared access to all its files to me and my colleages, although not to the people who read DEST.