Currently formulas only update between tables on the same spreadsheet page, but do not update where the formula references a table item in another sheet. This easily leads to errors as it is not expected behaviour and not obvious that the update has not occurred. PLEASE fix this issue.