use two different ranges in a formula

[Cloutier]

Sorry about the title, I didn't know to say it in less than 35 words!

What I'm trying to do is make a new table from data on other sheets. On the first data table (sheet 1), I have averages on cells B17:M17. On the second one (sheet 2), I have numbers on cells L4:L87.

On the new table, I want in B2: sheet1!B17/sheet2from L4, 7th cell down column L. In B3, sheet1!C17/sheet2!from L4, 14th cell down column L, and so on.

The problem I have when I type the formula in cell B2 and copy it down is that Excel doesn't know I want to move horizontally on the first sheet, and every 7th cell vertically on the second sheet.

Is there a formula that will allow me to do this?

Thanks for your help.