I wonder if it's possible to link tables from different spreadsheets.
I have several live projects running at the same time, for each I have a "Project finance" sheet, in which I have different tabs (Labour cost, Material cost, Project summary).
I would like to create a SUMMARY sheet with all my project, where I can link/mirror copy the project summary tables from all my projects. This needs to be "live", i.e. as we make changes in the project finance sheets (as the projects progress), on this summary table it would update automatically.
In Google sheet this is the formula I would use, but I only recently started using Numbers and I couldn't find anything similar in there.
=importrange("https://docs.google.com/spreadsheets/d/138XdwtZoMVsdMwJOzT4R8Zzg2NNc9pxTV-ARDPvHoj8/edit#gid=63426406","Customer finance!A1:N100")
You can basically create a "live carbon copy" this way.
Any help would be greatly appreciated.