Excel function

Hello,

please i need your help in the following problem


I have one worksheet contains many colums, rows, and calculations as follows:

employee id # name basic tax insurane total deduction net
100 mohamed 1000 50 200 250 750
101 ahmed 2000 100 200 300 1700
102 sayed 1500 75 200 275 1225
103 reda 3000 150 200 350 2650
104 fathy 4000 200 200 400 3600
105 baher 2750 125 200 325 2425
i need in another sheet to enter the id number and then get all its related information to be only for each individual or in nother mean for each employee id.

thanks for your consideration and i do appreciate your help

Mohamed Kadry