I currently have the following formula;

=OFFSET(Sheet1$A$1,Sheet2!$A$2,0)

I'm doing this so I'm moving down by the number of cells stored in the value of the cell Sheet2!$A$2. All good and works perfectly.

Now I basically I am copying this formula for other rows etc

=OFFSET(Sheet1$A$1,Sheet2!$A$2,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$3,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$4,0)

As you can see i'm wanting the value in Sheet2!$A$X to increase by a value. Now its not necessary by 1. I want this to increase by a value set in another cell. So it references the Sheet2!$A$<cell> Is this possible?

So just said I have value of 1 in cell A2

I want my formula's to be;

=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)

So it still refers to the Sheet2!$A$1 or say Sheet2!A$2 if the value in A2 = 2, or Sheet2!A$3 if the value in A2 = 3.

Hope this makes sense, can anyone please help?