Reference Cell as Sheet Name in Formula

Hi all,

I am stumped by this problem. I would like to dynamically insert a worksheet name into a formula. I thought the easiest way would be to type the sheet names into cells in the same row as the formula and then reference that cell to provide the sheet name. However, I cannot for the life of me get it to work.

=OFFSET(A7&"!"&$D$7,0,ROW()-25)
Value of Cell A7 = XPE


I want it to say =OFFSET(XPE!$D$7,0,ROW()-25)

Is this even possible? Perhaps it is returning the value of D7 in my current worksheet first?

Thank you for any advice.

Both work!! Thanks a ton guys, you guys are awesome.