I have two worksheets. The first worksheet has data in every 4th column ie a,
d, g, j, etc that I want to bring in to columns a,b,c,d etc on the second
sheet.

Using the offset function I either need to move the reference cell each time
or move the offset itself. How can I do this?