A finance-ready sheet keeps the export untouched on Raw, assumptions on Inputs, the working on Calc, and the answer on Output. The Calc tab already copies each order's region. Wire up the rest.
Convert every order to USDOn Calc, in B2, convert each order's amount to USD: look up its currency in Inputs!A2:B4 and multiply. One formula for all eight orders.
Revenue by region on OutputOn Output, in A1, total the USD amounts by region from the Calc tab, biggest first: =QUERY(Calc!A1:B9, "select A, sum(B) group by A order by sum(B) desc label sum(B) 'Revenue (USD)'")
The data, 4 tabs
The starting sheet. Cells outlined in green are where your formulas go.