Import csv into Workbook and format cells with formula to change data

I have a need to adjust a master excel file to accommodate a new process. I have a csv file that has data in A thru N with D thru K showing times in format h:mm:ss. This csv file is auto generated daily and will need to be imported into a master spreadsheet into a “data” tab keeping previously imported data in the sheet (new data would be added to the next available row below). Here is where I am running into issues. The master file is formatted differently.

The master file has data in A thru M with F thru M showing time in secs (showing 1800 instead of 0:30:00). I cannot change the csv original file to show anything other than h:mm:ss but need the master sheet to show secs due to lookups of other sheets in the file.
In the csv, column D and E need to be added together to import into H in the master file
In the csv, column G and H need to be added together to import into J in the master file
In the csv there is no date being pulled in. I need to be able to when the csv is imported to generate a date (currently doing this manually based on when the file is run).


Currently right now I am pasting the csv into a temp sheet in the master workbook and using formulas to copy, merge, convert, etc. the data into the “data” tab. Also I am manually entering a date into column A in the master file so that the data has a reference. (referenced in bullet 4 above). I would like to be able to create a macro that will do this much easier and with less steps. I don’t know if all this can be done with 1 macro or multiple of even if macros is the way to go. Any help would be appreciated. I have attached an example of the csv file with the data. Thank you in advance.

I have attached the master file as well for reference.

Thank you for looking at this. I am sorry for the confusion with my 2 files. I have compared the 2 files and listed how they map over from CSV to Master. As for the file format being 2007, I just saved it in the wrong format.

In the CSV "A" map to Master file column "C"
In the CSV "B" map to Master file column "F"
In the CSV "C" map to Master file column "E"
In the CSV "D" and "E" map to Master file column "H"
In the CSV "F" map to Master file column "I"
In the CSV "G" and "H" map to Master file column "J"
In the CSV "I" map to Master file column "K"
In the CSV "J" map to Master file column "L"
In the CSV "K" map to Master file column "M"

I have checked the file and everything appears to be working. Thank you for your assistance with this!