Hi

One way would be to use 2 cells on your sheet to hold the starting row
number (166) and the offset (13). lets say these are in cells R1 and R2
respectively.

in cell R7
=INDEX(+Equity!$E:$E,$R$1+($R$2*(COLUMN(A1)-1)))
Copy across as far as required

--
Regards
Roger Govier

"jordanpcpre" wrote in message
...
Is there a formula that will reference a cell in a seperate tab for every
13th cell.

For example: In cell R7 it looks at cell =+Equity!E166. Cell S7 needs to
be
13 rows below =+Equity!E166...

So, R7 equals =+Equity!E166
S7 equals =+Equity!E179
T7 equals =+Equity!E192

I need to repeat this for multiple colums.