Good morning, Hayley-
Replace this line
Nayme = ActiveCell.Value

.... with this one:
Nayme = Activecell.offset(0,-1).value

This will pick up the value in column B instead of column C.