Automatically set all CURRENCY format to only one selected in one dropdown list

Hi Everyone,

I trued searching everywhere over the internet and this forum, but I couldn't find anything on this. I hope someone can help me completely, I need to solve a problem in my worksheet regarding CURRENCY format.

Q:
I need to get this done:
To have just ONE cell that is defined with a dropdown list of preset various countries’ currencies, and each time when I click on the selected currency, EVERY cell in this worksheet which has a figure formatted with CURRENCY will automatically turn into that currency selected only in that dropdown cell.
Without the solution, I have still at this time just set all the cells with monetary amounts in simple NUMBER format, ie. no CURRENCY SYMBOL at all, till I find a solution ..

Could anyone help me ? Greatly would appreciate the solution that addresses my question.

Cheers
Jason (VBA dummy).