Auto populate packing list from separate worksheet

The column for the ID number may be populated using:

Formula:

=IFERROR(INDEX(Employees!G$2:G$13,AGGREGATE(15,6,(ROW($2:$13)-1)/(Employees!$A$2:$A$13=$H$7),ROW(1:1))),"")

The rest of the columns (after undoing the merge and center for Pins) are populated using:

Formula:

=IF($A18="","",INDEX(Employees!B$2:B$13,MATCH($A18,Employees!$G$2:$G$13,0)))

Let us know if you have any questions.