Hi all,

I'm sorry if this question is redundant, but i'm struggling with the references I've seen. I'm trying to drag/copy a cell with the formula = ='1'!$C$12. Ultimately I want '2', '3', etc. I'm aware that I can use =INDIRECT(), but i'm clueless when it comes to putting the appropriate values in. I've tried to replicate formulas I've seen in other threads with no success. Any help will be greatly appreciated.

Best