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.

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"] No[/TD]
[TD="class: xl65, width: 64"]Area[/TD]
[TD="class: xl65, width: 64"]Mean[/TD]
[TD="class: xl65, width: 64"]Min[/TD]
[TD="class: xl65, width: 64"]Max[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]131[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]119[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]107[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]37[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]207[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]102[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[TD="class: xl65"]255[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 615"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]filename of imported result[/TD]
[TD][/TD]
[TD][/TD]
[TD]filename of imported result[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]Area[/TD]
[TD] [/TD]
[TD]No[/TD]
[TD]Area[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]131[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]131[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]119[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]119[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]107[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]107[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]37[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]37[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]207[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]207[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]102[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]102[/TD]
[/TR]
</tbody>[/TABLE]

Greatly appreciate any help. Thanks!

Ouble

 

[Ouble]

to add...

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

Ouble