Hi all,

Hoping someone can help.
I've got a worksheet that has data laid out something like this:
A1: words
A2: words
A3: words
A4: words
A5: words
A6: 1
A7: 2
A8: 3
and then it repeats the sequence above, starting again with "words".

What I'm trying to do is write a formula I can drag down on Sheet2 that will copy ONLY cells A6:A8 and then A14:A16 and so on, but with no gaps between. So, something like this.

A1: =Sheet1!A6
A2: =Sheet1!A7
A3: =Sheet1!A8
A4: =Sheet1!A14
A5: =Sheet1!A15
A6: =Sheet1!A16
etc...

Does that make sense? Hopefully someone can help. thanks so much!!