I have a few sheets in excel, I have a drop down menu that has each of the sheets names in the drop down.

call it sheet2sheet 3 sheet 4 plus I have the first sheet "main sheet"

main sheet has the drop down menu, when I select sheet 2 from drop down menu, I would like it to pull all pricing listed in a column on sheet 2 to the main sheet