Formulas with Referenced Cells

[masterchibi]

Using Excel 2003.

So, I want to reference a cell from another worksheet/excel file.

The specifics of it is that I want to reference every x numbered cell. Example:
=Worksheet1!A3
=Worksheet1!A10
=Worksheet1!A17

However, when I try to drag and auto-fill the other cells, Excel makes a tantrum and outputs:
=Worksheet1!A3
=Worksheet1!A10
=Worksheet1!A17
=Worksheet1!A6
=Worksheet1!A13
=Worksheet1!A20
=Worksheet1!A9
=Worksheet1!A16
=Worksheet1!A23
=Worksheet1!A12
=Worksheet1!A19
=Worksheet1!A26

I want to get it to output 24, 31, 38, etc.

Is there a workaround for this without using macros/VBA?

I have tried using $ but that still ends up doing the same thing.

Thanks in advance!

[masterchibi]

Hello all,

Thanks to another user on another forum, he suggested using the formula:

=OFFSET(Sheet2!A3,6*(ROW()-1)-7*(ROW(D$1)-1),0)

Where Row(D$1) = the starting row of the formula.

However, I cannot figure out how the math works out in the formula. Can someone please explain it to me?

Thank you in advance.