Change booking date from form sheet to a table. Move Reference number to right.
In cell b2 of Daily Scan sheet enter:
=INDEX(Table1[First name of child],MATCH($A2,Table1[[Ref number]:[Ref number]],0))
Should be able to drag this to all cells.