MAX formula with input from every 4th row

Hi,
Im trying to Get the max value from every fourth row from another spreadsheet. My cells look like this:
MAX(Data!B34:Y34)
MAX(Data!B38:Y38)
MAX(Data!B42:Y42)

and so on. The problem is I have 900 rows of data so doing this by hand would take lots of effort. When I try to copy these formula ie. drag the green box down, in the next cell I get MAX(Data!B37:Y37) when i would want to get MAX(Data!B46:Y46). How can I keep the same interval in cells when copying this formula down?

Thanks in advance!

This works. Thank you so much!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

OK, Thanks for advice.