I am trying to find a formula that will allow me to pull data from a cell
that is contained in a set number of cells below the current cell. For
example, if I have data in cells A1:A30, I would like to have Cell B1 to
contain the data in A1, but cell B2 to contain the data in A10. Similarly, I
want cell B3 to pull the data in cell A20, and so forth.

Can anyone help?

Thanks!

Scott