Dragging Formulas - Skipping Referenced Cells

Hi guys,

I've got a slight problem I need help with. To explain it better, let's say I have the following data across a number of columns on one worksheet:

WORKSHEET1:
24 16 45 12 10 76 13 2 57 76 34 26 11 9 8 22 13 7

In simple terms I want to take some of those same values and place them in a different table on a different worksheet. In my case it's the 8th value along I want (in red). So ideally my new table would look like this:

WORKSHEET2:
24 57 13

Ideally I want an easy way to drag the formula across the cell and have it automatically populate the cells as above. At the moment all it does is re-create my original table. I have already tried selecting a number of cells before I drag so it knows what I want to do but this doesn't work either and it seems to have a mind of it's own taking data from completely different columns scattered about the place. It doesn't neccesarily have to involve dragging as long as I can easily populate these cells without having to manually go to the other worksheet to select the correct cells.

Any help is much appreciated! My boss will be very happy if I can help him solve this!