Changing Cell Formats Automatically for Currancy

Hi all,

Trying to get a pricing sheet I have to be a little more automatic and streamlined if you will. One of the issues im coming upon is changing the format of the cells when I select between 2 different values on another sheet.

I have a cell on Sheet1 and the options are Country A and Country B.
Country A is in Euro's
Country B is in Dollar's

So in Sheet2, 3, etc I need cell's changing the format of the value so it shows up properly as either Euro's or Dollar's without physically going in and changing the cells. I've been looking around seeing some other people doing things like this though I haven't been able to duplicate it.

Im guessing this is a VBA macro that needs to be made for this and still learning how to do this so asking for some assistance.

Thanks