Hi

I am trying to create a formula to copy data from one workbook to another.
The problem I have is that I want to copy only relevant data which is in
every 4th column.

So in cell A1 (destination sheet) I copy from A1 then A2 I want to copy from
A6, then A3 I want to copy from A10 and so on. Then the same for numerous
rows.

I need a formula that I can drag across so that I don't have to type a
formula for each instance because I will be using all available columns.

Hope that makes sense and someone can help. Thanks in anticipation!