I would like to take data from various workbooks and pull the information
contained within a range of cells into one main sheet.
I'm thinking that I would like to use a drop-down menu to make the selection
then all the data would populate in the cells underneath from another
worksheet.
Could someone point me in the right direction??