Update a worksheet based on other worksheets

Doe,John.xlsxSTAFF LIST.xlsm

I need to update the Staff List based on the info in the workbooks with an employee for a file name. In the staff list, I want to end up with the employee name in column A followed by the info in cells K5, L5, M5, and N5 from the workbook with employee name for the file name. I want to do this for every employee workbook in the folder. Using the VBA macro in the attached Staff List, I end up with too many columns in my results. Please correct my VBA macro to give me only desired results.