If you have duplicate names, this will only returns first employee's date

=INDEX(Sheet1!C4:H4,MATCH("A",INDEX(Sheet1!C5:H9,MATCH(C5,names,0),0),0))