Formula or VBA that will search for a list of numbers and return the row entire string

Hi all.
I am looking for a Formula or VBA that will return entire test strings based on a list of numbers. for example I have a spread sheet as follows and I would like to cut and paste a list of employee id numbers into a sheet and have the macro or formula return the entire row of information next to that number. Name, address etc.

I don't want to have to enter each one individually as there is over 2000 rows of addresses etc. I have attached a sheet that will nearly do it but you have to enter a one value at a time.

Capture.PNG