Sharepoint and web-shared files make it very difficult to link spreadsheets between each other, even one way around.

In theory it works, in practice it doesnt. (PowerQuery is an inconvenient stopgap to simple links)