Open TXT File Using Excel VBA?

do a code to open a closed .txt file. Once opened, the data inside of it should be copied on the macro workbook sheet 2 column F. I want the macro to perform a loop until all the .txt files have been opened and copied on the specified sheet and column. No worries I will still include some codes in between .txt files so no overwrite will happen. By the way I want to open the .txt file in sequence base on the file name listed in sheet1 column B2 onwards.

see below list

File Name

1.txt
2.txt
3.txt
4.txt
5.txt
6.txt
7.txt
8.txt
9.txt
10.txt
11.txt
12.txt

So the first .txt file to be open is 1.txt followed by 2.txt and so on it will loop until all filenames have been opened and copied. Path of the file will be in C:SAMPLE