Serching data using text box in user form

Dear friends,

I have created a user form in excel. In this form I am allowing user to enter employee code, now i want that after entering the emp code it should search the following data.
A.
1. name, 2. dept., 3. plant., 4. desig. -- all from Master sheet
B.
1. Training Needs(one emp has more than 1 need) --- from Need sheet
C
1. training detail which had taken. -------all from Master Sheet.

can anyone give me the codes to create such a program. I know the codes will be too long. But I really want this.