Recently found this handy way of importing several text files into a single Excel workbook and each being assigned to their own tab. Check out this short and simple explanation inclusive of the code (in Visual Basic) here:
https://www.extendoffice.com/documents/excel/3231-excel-import-multiple-text-files-to-multiple-sheets.html#a1