When you open this, make sure that you change the links to your "Master_Time_Sheet" - it may be looking for mine. If you store them in the same folder, the links may work.... I have assumed that the list of names always has no blanks within the values, only at the bottom....

Client with Name Validation.xlsx