--------------------------------------------------------------------------------

I am a junior VBA programmer, I am stuck on this case, could somebody help me out?

WB1 has 3 worksheet, every sheet has a range of data in GBP. I need to multiply the data in WB1 by certain rate to another currency (USD) and save in WB2 3 worksheet. I need to write macro in WB2. WB2 and WB1 is same format, except different currency rate.
WB1 could be different name and path. Everytime after I run macro in WB2, the macro asks me open WB1, use the exchange rate in WB2 cell (C2)(exchange rate is variable everymonth, I have to type number before run macro ) to convert all the data in WB1 and saved in WB2.

Thanks a lot