I need some hand holding please. Zero experiences with VBA - step by step appreciated by me and the hordes of newbies...

I need to import multiple text files into an Excel spreadsheet.

the files are simple text, single line, single column no parsing needed.

I want to import multiple files into a column in a worksheet

folder = /filefolder/
files = textfile-01.txt
textfile-02.txt through textfile-250.txt

I want textfile-01.txt to be in C1
I want textfile-02.txt to be in C2 etc.

I got as far as ALT+F11 opens VBA editor....

thanks in advance