I have a list in an excel worksheet with the data going down it one row at a
time (eg. row 1= data 1; row 2= data 2)

I want to link these cells to another worksheet but the data needs to be
spread out with 4 rows in between each entry (row 1= data 1; row 5= data 2;
row 9 = data 3 ...)

My problems lies in not being able to copy the formula down the page as it
is adjusted automatically according to the number of rows between the new
target cell and the cell from which I have copied the formula from. I have
tried entering several of the formulae with the correct increase and then
tried to drag the formula down the page but the answers I get are as wrong as
they are frustrating.

Please help!

:-)