Invoice Macro - How can I load stock numbers & link to product description

Hi
I have used an excel invoice macro, modified it (extra columns & formulas etc). I want to type in item stock numbers in one column and automatically call up the corresponding product description in another column. My stock is in another workbook although i have also copied it to the invoice workbook as a separate sheet but don't know how to achieve the result.... Help!!!!
Thanx