As it is easy to create sequences of numbers in cells, you can combine INDIRECT() with references to consecutive cells.
If A1 contains 30, then this formula:
=INDIRECT("'1'!F" & A1)will refer to cell F30 on a worksheet named "1"
If you create a series in column A (30, 31, 32 etc), then drag the formula down to extend it, it will refer to F30, F31 , F32 etc.
Another way to get a sequence without using numbers in other cells is to use ROW() in your formula. ROW() returns the row number of the cell containing the formula, so this formula in Cell B1:
=INDIRECT("'1'!F" & ROW()+29)also refers to cell F30. Drag it down to B2 and it refers to F31.
Hope this helps