Import multiple excel data to a single worksheet in specific columns

[Ouble]

Hi all,

I have searched the web for hours but was not able to find a solution. Kindly help. I need excel to transfer all excel results into a single worksheet.

1. Click of button, file directory will open and select the folder where all the excel results are located.
2. Below is how the data looked like.

No	Area	Mean	Min	Max
1	131	255	255	255
2	119	255	255	255
3	107	255	255	255
4	37	255	255	255
5	207	255	255	255
6	102	255	255	255

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

3. I will need the filename of the imported result to be at top left of each import.
4. There are 5 columns in the result sheet (A,B,C,D,E). I will need to import only column (A,B).
5. It will look something like this.
6. With a column spacing in between each imported results.

filename of imported result			filename of imported result
No	Area		No	Area
1	131		1	131
2	119		2	119
3	107		3	107
4	37		4	37
5	207		5	207
6	102		6	102

<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Greatly appreciate any help. Thanks!

Ouble

 

[Ouble]

to add...

the imported data will be in the same sheet as the button

Ouble