The front sheet will be the graphical display/interface to summarise where people are sleeping, the important data being on the individual sheets.

As the rooms have varying speciality equipment, individuals may/will need to move to other rooms due to changes in support needs.

So when I change the room number (B5) of any individual sheet to another room, I need the name in D3 (individual sheet) to move to the corresponding room cell on the front page e.g. D2, E2 etc