Invoice population from different worksheet

I have an invoice in excel that I want to be able to enter the qty and the item number and have it populate the description, type, unit price and line total (the discount must be added manually bases...