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 a...