Importing data from text file

Ive tried searching and using different methods and cannot figure this out. About 2-3 times a week I have about 25-100 different text files that I periodically need to import data from to my spreadsheet. The name of the text file will change each day but I am able to paste the titles in row 1 on my spreadsheet. Also, all of the text files are saved to their own folder each time and are not comingled with any other text files if that makes it easier.

Ive attached a spreadsheet with the layout I am using and a sample the text file I am importing data from.

Thanks in advance for any help.