Macro loop: Copy value down until it meets next number

[bone123]

Hi, I am new to this and wonder if you can help.

I have a text file which is generated from a mainframe computer. I need to sort the data but since there is no identifyer, I need to create a column, copy the name (highlighted in the yellow lines) from the cells that start with 'ACCESSORID = BSaaaa NAME = AAA'. Note that the 'aaaa' are numbers and will be different for each record, and so as 'AAA'.

The name can be extracted from these lines and be taken from the characters after 'NAME ='

So hopefully, I can use a macro to create a new column (say A) and copy the cells with names down in the new column (the name will change at every few lines when the record in the adjacent column changes.)

Thanks very much in advance.