Need help on Excel Macros

Hello,

I am not a techie and I have very limited knowledge on Excel Macros.

I have two worksheets.

Worksheet 1 - Employee information like Employee ID, Name, Department, Gross Salary, Tax Information, etc
Worksheet 2 - Employee information again

My requirement is:

If I enter Employee ID in a cell in Worksheet 2, I should automatically get limited information like Department and Gross Salary from Worksheet 1.

Please help.

Regards
Sinras