Looping Through Txt Files in Folder and Pasting Contents to Worksheet

Hello,

I am new to VBA and am wondering how I can loop through a folder containing multiple .txt files and paste the data into worksheet cells. These are tab delimited files.

Some of the requirements are..

1. I want to start reading each .txt file from the second line. The .txt file has headers that I don't want in the worksheet.

2. Each row of the .txt file needs to be placed into its own cell, going down a single column. For example, if the .txt file has 5 rows, the worksheet will be filled (A1:A5)

3. Each file in the folder will be separated by a blank row.


Any help would be really awesome! Cheers.