Inserting new rows automatically based on a common field

[victoria2207]

Good Morning,

I am creating a workbook which will have 4 tables, 1 master, and 3 feeding into the master based on a common, unique, value (Reference).

What I want to know, please, is if it is possible to set the spreadsheet so when someone enters a new reference on the Master (or inserts a row for that new reference), that it automatically inserts a new row/reference on each of the other sheets.

TIA,

Vic2207