Hi there...I wonder how can I get excel to autofill the next column if....my sheet is like below...

employee ID employee name employee dept.
00001 john doe training
00002 funny gal engineering

etc etc

can my worksheet get the data from elsewhere and i just need to type in the employee ID number and the rest will be filled in from the linking excel sheets or workbook? Is this possibble...thanks..

Jayman