I've got a worksheet that references another worksheet, but I need to reference every 30th cell on my reference sheet to each row on my main sheet, but I can't get the trends to understand what I'm doing.

More clearly...cells A1, A2, A3 on sheet 2 would reference cells A1, A30, A60 on sheet 2. So then I would like to be able to copy the forumla so it automatically adds 30 to the cell number instead of incrementing by 1 like a normal formula copy.