Pulling down equations from other sheets, with data in every 4th row

[montanaaggie]

In my second tab, I have customer details. Each customer is made up of four rows of data. Below is example only

B1Ford
C1 10

Now B2:B4 would list Ford but, C2:C4 would listen different details. Starting in Row 5 a new customer would exist but with different data.

On a new tab I want to link to only Row 4 for each client. So B1=(B4 on the other tab), and C1 = C4 on the other tab. B2=B8 on the other tab and C2=C8 on the other tab. The problem is now that when I highlight both these rows equations and drag down it doesn't skip the 3 rows I need it too.

Any insight/guidance is appreciated.

Dave

 

[tweedle]

I'm sure you'll get a more clever answer than this, but until then
You could give the INDEX function a helper column (i.e. Col G in example)
NEW SHEET G1: =4
NEW SHEET G2: =+G1+4 ;Copy Down

NEW SHEET B1: =INDEX(Sheet1!B:B,Sheet2!G1,1)
NEW SHEET C1: =INDEX(Sheet1!C:C,Sheet2!G1,1)
Copy both B1 and C1 down