Repeat Formular Pattern

Hi All,

First off sorry if this is in the wrong area!

I have been trying for hours now to get this to work and its doing my head in now. I have been all over google trying to get this to work but I just cant seem to get it.

I have some data on Sheet 2, and I want to display it on Sheet 1. On Sheet 2 the data starts at cell C2 then the next is in I2 then O2 etc (so every 6 cells but starting 3 Cells in.)

I want to show these cells on Sheet 1 for example B2,C2,D2. I have attached an example. I have tried all kinds of OFFSET, INDEX and other formulas but just cant get it. Any help would be great.

Thanks!

Say, in Sheet1 cell B2, type in...

Formula:

Please Login or Register  to view this content.

and copy to the right.

You sir, are a legend, worked in every instance in the worksheet im making. Thanks so much!