Here is one for you... I want to make a workbook with the following
ability.

Pick an item from that drop down list in column "A" and it shows a price
in column "B". I would assume I need a second sheet with the data
paired up, but how do I set it up to pull said data to another sheet?