macro to compare data sort and delete buys vs sells

Hi Guys i have a attached a sheet for which i need to create a macro. I am not sure where to start that why i am listing all the criteria for it. Just as a heads up i am using lines 5 and 11 to elaborate what i am looking for

-first i want to go through the product type and see if any match in the file that i have attached cells B5 and cells B11 match. ( EUR/USD)
-second, if D5 and D11 match i want to add cells E5 and E11 if not i want to aggregate them so in this case i would like the final output to look something like this --


EUR/USD S 6,000,000 USD 1.35237

in the end i want the final output in a different sheet but using the same format from column A to G.

Thanks