Excel to automatically format a text file and create tabs

Hi,

I have a text file that i'd like to convert to excel file to automatically format the file and create tabs for different type of messages. Currently i have to manually insert the text file and use text to columns to separate the data then filter and create separate tabs (labeled the type of message) for each type of messages. Also if possible before creating the tabs, i'd to create a master tab of the original file. I've attached the sample text file. Thank you in advance!

I tried to attach the jeanie code, but doesn't seem to work right for me, so i've attached the excel file of how i usually format the text file.