You can use the INDIRECT function. For example,

=INDIRECT("Equity!E"&166+(COLUMN()-18)*13)

Here, change the "E" to the column letter from which to pull the values from
the Equity sheet, change 166 to the first row on Equity from which data
should be pulled, change the 18 to the column number of the first cell in
which the formula appears (in this case, 18 = column R), and change the 13
to the number of rows to skip when pulling data off the Equity sheet. Then
select the cells that are to contain the results and CTRL R to fill to the
right.

Rather than hard-coding these values in to the formula, you might want to
put the values in cells and reference those cells in the formula.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"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.