Importing a text file

[Lothar69]

I am needing some help to automate a time-consuming process. I have a .txt file that I get on a monthly basis that I would like to import into excel to elminate the manual process of putting the text file into a meaningful format. I am attaching my workbook for reference purposes.

In the workbook, column A contains the actual data imported from the text file. I would like to take the data from column A and split it out into a more meaningful format. The sytax of each line of data is as follows:

nesplss001_SeqNumApplicant:50

This syntax breaks down in the following manner:
nesplss001 = the machine number
SeqNum is meaningless to me
Applicant = the category
50 = the number of submissions for that category on that machine

I would like to put this information into a table so that each machine number is listed down the left column and each category is listed across the top. I would like to automate this somehow so that I don't have to manually record the totals in the table.

Any thoughts on how to accomplish this?