"Jeremy" wrote...
....
occurs in the same column in every 30th cell. In my new sheet, I want my
column of information to refer to every 30th cell. In other words, I want
h28, h58, h88, h118, etc. Unfortunately, I don't know how to make excel
....

Three responses all using INDIRECT. If you like slow recalculation, use
INDIRECT. If you have any interest in faster recalc, and if the first such
formula would be in cell B2 in newsheet, try

newsheet!B2:
=INDEX(othersheet!$H:$H,ROWS(B$2:B2)*30-2)

and fill down.