Convert Dat File into different layout format and into CSV Format

Hi Guys,

Really struggling on this one as it's so far out of my excel knowledge it's untrue.

I've got this file attached.

Sheet one is the .Dat file that i've converted into excel format using delimited by +.
Sheet two is the output style I've created by using simple vlookups

What I want to be able to do is set up a VBA excel file that takes files in a folder within .Dat format and then automatically convert them into the sheet 2 format and then save as a .csv file in the same folder.

Is this possible?

Many thanks for any help