Drag fill only every other cell

HELLO

I would like to paste some subtotals in a sheet (sheet2) in a row from another sheet (sheet1). easier is to just say first cell in sheet 2 = first subtotal in sheet 1 and then drag......
BUT in sheet 1 I have blank cells in between the subtotals and in sheet 2 I don't want those blank cells but they copy across when I drag the fill handle.
How can I skip those unwanted cells when I drag to copy and fill. I want the cells in sheet 2 to = those in sheet one.
I do not want to add hidden columns to sheet 2 to match format of shet 1 because that will mess up the chart.
Please advise and thank you in advance.

Instead of a simple link, like

=Sheet1!B2

Use a formula that will be "copy-able" like this

=INDEX(Sheet1!2:2,COLUMN(A1)*2)

You just need to know the first cell and the spacing: with a spacing of 3, and the first cell in column E (E2) instead of column B:

=INDEX(Sheet1!2:2,COLUMN(A1)*3 +2)

For the first cell, this part COLUMN(A1)*3+2 evaluates to 5, returning the value from E2

This shows the result of a column of those formulas starting in cell B2: