Excel Pattern Recognition when Copying a Formula

I am trying to copy a formula down one row, but the data is from every third row on a different sheet and Excel isn't recognizing the pattern. I've built the pattern out seven times so it should be able to recognize. Yeah? The data is from a SmartView grid, and I don't want to change the layout for analysis purposes.

Example of what I want... 

Tab "MOM SPD % CHANGE" Row 8 =+Essbase!F27/Essbase!R24-1

Tab "MOM SPD % CHANGE" Row 9 =+Essbase!F30/Essbase!R27-1

Example of what is happening... 

Tab "MOM SPD % CHANGE" Row 8 =+Essbase!F27/Essbase!R24-1

Tab "MOM SPD % CHANGE" Row 9 =+Essbase!F28/Essbase!R25-1

Thanks!