Basically I have this formula:
=(MIKE!$B8)
and I have a bunch of cells withs Numbers like so:
Cell | Cell Number Change
C1 | 10
C2 | 16
C3 | 29
C4 | 40
C5 | 61
What I want to do is to be able to change the number "8" for the formula by referencing a cell to grab a number, which will thus change the formula and the output of the data. I'll use it to copy and paste down and change the numbers out to get only the output of different cells that I need.