Batch import and collect results in one worksheet

Hi

I have been looking around the forum but couldn't quite find a solution to my particular problem.

I have many sets of 2 txt files with results that need to be analysed on a excel spreadsheet. The result of each analysis is one column that i would like to save on a single worksheet.

The txt tables are put on the first sheet on A1:C1001 and E1:G2, then the relevant subsets are picked and transferred to sheet 2 where some formulas take care of the analysis and I want the resulting column F to be saved on a "collecting" sheet for each data set. So with each iteration of the macro an additional column would be filled in. Now this is easy to do for a single set, but I have several dozens and most importantly I need one sheet with all the results columns next to each other and named (value in row 1) by the filename of the original txt file. Is it possible to do this with Excel macros?

Thanks a lot!