Cell References: How can I use a formula to tell excel what cell to reference?

Deel_Engineering 

An alternative could be these lines of code. In the attached file you can click the button in cell B5 to run the macro. The values of the referenced cells are then listed in column E.

Sub reference_cells()

Dim i, j, k, l As Long

Range("E:E").Clear

i = Range("A" & Rows.Count).End(xlUp).Row
l = 16

For j = 51 To i Step 36
Cells(l, 5).Value = Cells(j, 1).Value
l = l + 1

Next j

End Sub