Select value from Data by using VBA or Macro

Hi There,

I need to print 500 forms for employee (First spreadsheet “MainForm”) ,

I have got list of employee (second spreadsheet “DATA”), I would like to select an employee at cell d4 (MainForm) and cell d21 will update the detail via vlookup

I tried to create list at celld4 but it did not work, I would like to select an employee at D4 from “data” spreadsheet

I really do not want to copy and paste!!!!!

Can anyone help me please!!!!!!

Thank you,