Linking between tables in different spreadsheets in Numbers
You can reference every table on every sheet by name/title, as long as they are within the same document.
(In the screenshot below, there is a table &quot;Material Cost&quot; in the sheet &quot;Material Cost&quot; with some values in column B that add up to 15.)