Table syncing

I am currently writing an excel workbook to analyse material contents of various yachts for Life-Cycle analysis and was wondering if you may be able to help solve an issue I have?

Attached is an example file which I have made with ‘Vessel 1’ sheet showing the referencing style, and ‘Vessel 2’ with no referencing. The codes are intentionally duplicated in some places so they cannot be used as ID.

What I am aiming for is to have the “Primary_Data” table to be where rows are added and amended, and then for these amendments to automatically sync with the vessel specific tables. At the moment, if I were to link the first three columns (Code, material, and Dis. Type) using ‘=’ referencing, they would sync but the following columns in the vessel specific tables (Mass and %) stay as they were. So for example, if I were to add a row between fuel and teak, the vessel tables update those columns, however the mass and % values do not move and would incorrectly display the ‘test’ as having a mass, this test mass and % is actually the teaks...

If there a way to fix this with VBA coding or queries?