I have a multiple worksheet form which is used on one worksheet to register attendees on one worksheet and then displays their names on a table plan on the next worksheet using the concatenate function to combine forname and surname.

The problem comes when I cut and paste people around on the registration page I get #ref on the tableplan. If I use copy / Paste Values it is Ok but a nuisance as I have to work at speed once registration is complete.

Is there a way do display the contents of Attendeelist-A1 in Tableplan!A4 rgardless of the editing and changes which are made. i.e Tableplan!A4 always reflects the current cell contents rather than tracking the values when they are moved about into different cells