Extract data from specific txt files in folder

[angmtz]

Hi does anyone have a VBA that will extract data form only specified txt file in a folder?
Example i have a folder with 100 txt files with names 1.txt 2.txt etc.

I want to extract the data only from 1.txt 3.txt 94.txt

preferably if the vba can read a column with the names of the files i want to extract the data from and extract the data to the next column.

1.txt	data from 1.txt
3.txt	data from 3.txt
94.txt	data from 94.txt

 

[Joe4]

Welcome to the Board!
We need a few more details.

Where will this list of files to be imported be maintained?
In the same file as the VBA code?

What exactly does your data look like?
Is it just a single field (column) in each file?

What shuld the resulting file be? An Excel file, or a Text file?
If a Text file, how should it be delimited (i.e. space, comma, tab, etc)?