Update Existing Excel VBA Macro to incorporate COGS

We have an existing Excel Macro which we would like to update to include a new sheet which will calculate COGS for each order that is processed from the csv file when the macro is run.

Details are of the project can be found in the attached pdf file.

Here are the files which include existing macro and test CSV files:

https://drive.google.com/drive/folders/12oSqwJ-mpFUfjjNHKXfUmkVNmXaE9eCJ?usp=sharing

6-2-23.csv is an example of the current format of CSV file we run through the macro, which deducts inventory from Stock management and the associated SKU's, as well as generating an XLSX file which formats the data to make it more user friendly when processing orders.

export(32).csv is an example of the NEW format of CSV file which includes the addition of financial data required in order to calculate and formulate the COGS for the new sheet (relating to the new task).