Excel Pattern Recognition when Copying a Formula

[MDLeach]

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!

[#2 · Accepted solution]

@MDLeach 

In row 8:

=INDEX(Essbase!F:F, 3*ROW()+3)/INDEX(Essbase!R:R, 3*ROW())-1

Fill down.

[#3]

Thank you, Hans Vogelaar.