Simple Cell replication

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

I just get #ref with Indirect

You are right all I want to do is display the contents of A1 regardless of what is copied into that cell, on a different worksheet

That is perfect, can I combine it with a concatenate function to display the forename and surname in the same field?

Great many thanks