offset using formula

[rwl518p]

I have a spreadsheet where in column A I need it to return the contents of cells from another spreadsheet called PASTE. =PASTE!A133 in A1, =PASTE!A166 in A2, =PASTE!A199 in A3 and so on. How can I do this to be able to easily drag the formula down?
Got to be simple, but my brain just won't engage this morning.

[Pete_UK]

Do it like this in A1:

=INDEX(PASTE!A:A,100+ROWS($1:1)*33)

Then copy down.

Hope this helps.

Pete

[cbatrody]

OR,

Try the following in A1:

=INDIRECT("PASTE!A"&100+33*ROW(A1))

drag this down the cells.

[rwl518p]

Brilliant ... all working now