Excel Question about linking workbooks

Hello,

I am having a hard time figuring out how to link workbooks. I would like to have a main workbook that we number with a job number and a row of data like name, company, etc...

The second workbook would be a work order sheet and when I type the job number from the first workbook then the data from that row will auto-fill into the work order.

Like this:

Job Numbers.xls:

10-066 Joe Smith RMG Corp. 253-665-2342 etc...

10-067 Phil McCracken ABC Inc. 235-334-6543 etc...


Work Order.xls:


Job Number -- 10-066

Company -- Joe Smith

Name -- RMG Corp.



Is there anyway that I can do this with Excel??