Search and Find Match Values and Paste Match Values to a Row

[jeffheartnet]

Hi there I want to ask for any help where in I have a search cell in sheet1 and my data base in shee2, what I want
to do is when I type the Employee Code in Cell B1 the records will appear in Row A2 downwards.




Any help would be appreciated much. Thanks.