Create script or excel macro to autofill spreadsheet from MT5 HTML/Excel statement

I use EdgeWonk trading journal software to journal my trades. I want someone to create some sort of script or macro to autofill the Edgewonk generic spreadsheet with all my closed positions from my MT5 statements.

I have attached the Edgewonk generic statement and a screenshot of how the cells need to be formatted.