Populating table with data from another table in the same workbook based on criteria (VBA)

Can some one help me with the VBA coding? I am trying to figure out how to populate a table with the data from another table on the different sheet based on criteria entered in the cell. I want to be able enter company ID into cell B2 (Please see Example attached) on Sheet 1 and have Table 1 (Sheet 1) populated with Employee ID's (cells starting A7 through how many there are employee ID's in the Table 2 on the Sheet 2). I want this command to be executed after I type in company ID and press enter. For example, if I enter ABC into cell B2 and press enter I would like to see EE ID 001736727 in the Cell A7, 690608470 in the cell A8 and 113506877 in the cell A9. I have up to 2000 ID's in the real table. Can some one please help me with this?