change sheet reference but not cell reference

[Upallnite]

Hello ~

Can someone assist in helping me with correct formula.
1. I have 12 sheets (Jan, Feb, Mar, etc...)
2. I have a master sheet to "recap" the 12 sheets.
3. I have the first formula to read " =JAN!E49 (which means I am pulling information from Jan sheet from cell E49)

Now, I want to copy the cells down and have JAN to read FEB and keep the E49 (=FEB!$E49) so I have entered a $ to keep the E49.

so my question is - how do I tell the formula to change the sheet name and Keep the cell when I copy down. (I know to utilize the $ to keep the cell, I just need to know how to tell it to change the sheet name - is this possible?)
example
=JAN!$E49, =FEB!$E49, =MAR!$E49, etc....

 

[Fowmy]

Hi,

May be;

=INDIRECT(ADDRESS(49,5,1,1,TEXT(DATE(1,ROW(A1),1),"mmm")))

 

[Upallnite]

Hi,

May be;

=INDIRECT(ADDRESS(49,5,1,1,TEXT(DATE(1,ROW(A1),1),"mmm")))

I was reading up in indirect but I don't understand how it works. I tried to comprehend it. I will give it a try. Thxs