Excel macro

Job ID: 33010837

Budget: $30 – $250 NZD

We receive .CSV files from a supplier and they need to be converted to a difference .csv file for upload into our job management software - Fergus.
I manually extract and convert the data. I would like an excel macro that I can put multiple .csv files in, it will extract the data and generate the .csv file I require.

Attached - Raw Data and workings (i've already collated the multiple tabs) and completed data.