Change Cell Ref inside a formula

I would like to link all the cell references in my worksheet formulas by reference to an external cell.

I have monthly financials for each of my store locations. Each of the months are listed in separate columns from left to right (ie. Jan in column B, Feb in column D, etc).

I also have a summary worksheet that list the current monthly financials for each of the stores in columns (ie Store 1 in column B, Store 2 in column D, etc). I do to this with a very simple = link to the current month in the worksheet noted above.

I would like to automatically change the cell references in the summary worksheet so that I can move quickly from Jan to Feb. I can use Find and Replace (change $B$ to $D$). However I would rather locate the monthly refernce in a key cell. In this key cell I would simply change B to D and all the formula references in the worksheet would change.

Someone mentioned the use of "&" embedded in the formulas. Unfortunately I can figure this out or find any reference to this in Microsoft help or knowledge base.

Can anyone help?

I have a worksheet named "Monthly".
A B
1 Sept Oct
2 Rev 100 150
3 COGS -75 -50

On a worksheet named "Summary" I have designed the following:
A
1 Current Month
2 Rev =Monthly!A2
3 COGS =Monthly!A3

I would like to establish a key cell on Summary, say at A5. This cell would have A or B. If I input A on this key cell, then the results for would be 100. If B then 150.

I tried =INDIRECT(A5&!A$Monthly&2)

This did not work.

Hope you can help.
dht

You could try

=INDIRECT("'Monthly'!"&A5&2)

This does the trick!

Thanks