I have a master register sheet, each row consists of 5 columns of data
specific to that row.

There are 6 sheets 'connected' to the master register

I need to add additional rows to the master resgister(to be sorted
alphabetically)

How can get the 6 attached sheets to reflect the sort, making sure that the
column data associated with each row is 'carried'?