Data Transfer [Closed]

I'm trying to get a spreadsheet that I've set up as a template for Commercial invoices to have particular fields populate with other data such as "description", "HTS Code", and "Country of Origin" when you type in a Item# into a column.
I have all the regulatory data ("description", "HTS Code", and "Country of Origin") in the same workbook on another tab. How can I do this?