School Directory Using Consolidation And Deletion Of Rows?

Here's how my project will need to work. I need to transfer text files(.txt) to the same workbook, but 1 worksheet for each text file. In here, I can choose multiple files. After that, I need to delete WHOLE rows that has a blank cell(except 1st column), starting from row 4. Then the last requirement would be to fill the 1st column, a portion of the text file's name.

First, I need to click the command button in order to choose the files I want to load. first.png

And then, if I chose two .txt files. It will also load two text files. In here it is, CLASS 2014 and CLASS 2013 second.png

What I want to happen next is for "2014" to be inputted in columns 1, rows 5 to 15. And then delete rows with blank cell, in which here is rows 8, 10, 11, 12 and 15.