Dynamic Indirect Reference

[grifdoogindoggy]

I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet.

So far I have this in cell B2:

=INDIRECT(B$1&"!O2")

Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want to be able to drag this column down So that in my B3 cell I have something along the lines of:

=INDIRECT(B$1&"!O3")

but it just repeats the same formula over and over as the cell above.

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1111445-dynamic-indirect-reference.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.