Suppose the name is in A 1: A 10.
Use formulas to directly refer to the contents of cells (direct reference formulas and random function formulas)
= indirect ("$ A" & ampRANDBETWEEN( 1, 10))
In addition: if the name is in column B, change "$A" to "$B"