I have created a detailed worksheet that assigns item numbers to entries in
Column A that correspond to item descriptions (text) in Column B. (This
worksheet lists all products for sale by my company.)

I want to create a new worksheet that is a summary page of the above. Only
actually items purchased (Column D "Qty" is selected), will be carried over
to this worksheet. I want this worksheet to autfill in some way. Perhaps
when an item number is entered into Column A of the new worksheet, Column B
will autofill with the corresponding information from the first Worksheet.
There are about 30 possible item numbers/descriptions that could fill any
particular row. How do I formulate an equation for this much information?