I am really new to arrays and it has definately been a struggle to understand how they work.
I need help to create an array of data from an external wb using an inputbox to select the data columns via their header cells and using a predetermined number of rows.

so how to build the array if the inputbox results are like [$C$1:$E$1, $M$1:$Q$1, $A$1] and the rowct = 100?

along with that, how could i add to that array something like the sheet name and column letter above each of those data columns.
for example the array output for the first column of data $C$1 would be like:
1. sheet name
2. column letter ('C')
3. the column header (value of $C$1)
4-102. data from $C$2:$C$100

then the next output column would be placed next to that one...and so on.

I truely appreciate any input here,
Thanks in advance!