Loop through column to find EID then find date and paste corresponding data

I have attached a sample file with a before and after tab though please note that output should be in another workbook. and i only have a few trainees in the list but the output file may have more and i need to look for the EIDs in the first tab, locate them on the output file before i copy over data. if the EID is not found, then i copy the data on the next available row.