Help with formula

[Mike]

I am trying to set up a worksheet to select peoples names
from a different worksheet and place it in a form ready
for printing its quite difficult to explain so i have made
a small version of it, if anyone is good at formulas i can
send it to you to see if you can help, Thanks

Mike