As stated a macro could do this easily. You would just need to activate the desired sheet pull the data from that column, place it where you need in your original sheet, then activate the next sheet and repeat that process for an many sheets as you to combine. Drop downs are made using Data Validation---List---Select the range you want for the drop down options the click ok twice. Contact me if you need the exact VBA script to run this scenario. I would need the worksheet names and columns where the desired data is and the cell references on where you would like the data to be combined. Thanks
