|I'll leave it to you to figure out the correct columns to use for this method...|
To convert the currencies, I would build a Lookup table with the currency symbols and the exchange rate as follows...
1 AED 0.272257
2 USD 1
3 JPY 0.010067
Then I'd split the amounts in Column B into 2 columns so I could look up the currency symbol in my lookup table.
With the symbol in Column B, the amount (without the symbol) in Column C, I'd put this in Column D:
This would look up the symbol in the table and multiply the number in C1 by the exchange rate. When you update the exchange rate in Column I, the converted number would update also.
To sum the values by message number, I'd use SUMIF: