Thread: Microsoft Excel question

I have a workbook that has many worksheets (Sheet1, Sheet2, etc.,)

Let's say on Sheet1 I want to reference values on the other sheets (Sheet2, Sheet3, etc.,), but I want to quickly change which sheets those are (i.e., sometimes I want to be referencing Sheets 3 to 5, another time I want to point to Sheets 9 to 11).

So, whereas normally in the formula for a cell in Sheet1 I would write a absolute reference like this:

=Sheet2!B2

.... what I want now is to replace the hardcoded string "Sheet2" with some kind of reference to another cell on Sheet1 that will contain a formula that I can easily change to different Sheet #'s as needed.

Any ideas?