Worksheet1 - data listed by account number.
Worksheet 2- same data, listed by surname.

Whenver I add a new row to worsheet 1, I have to add the same data to
worksheet 2, manually.

Is there a was to make worksheet 2 a dynamic copy of worksheet 1?
That is, whenever I update worksheet 1, worksheet 2 is automatically updated,
and the order of the rows is kept?