hyperlink or formula

I have a spreadsheet that requires me to see the status of every employee. What I want to do is just to type their employee number and all information and status regarding with this employee should appear next to the number i type. My database is on other sheet while I want to work on the other sheet. A formula or hyperlink can do this job? Any help will be appreciated. Thanks.