Multiple Inputs with Dropdowns output to single Output sheet

[TransformTitan]

I have a case where i need to use multiple input files of same design

to update different columns in single output.

columns would be determined on the dropdown values 

as shown in figure the is s browse tool for file selection and dropdown.

similarly, there will be 6more browse with their 6 dropdowns respectively.

I tried macro input. but could go forward.

[ChrisTX · Accepted solution]

A Drop Down tool only allows for one selection.  The List Box tool allows for multiple selections.

Chris