Reference cells by skipping a cell in the source

Hello,

I'm working on a project where I need to reference cells from a Source sheet. The data in the Source sheet is filled in cells with one blank cells in between so the data is for example in cells A1,C1,E1,G1,I1,K1...

So in the sheet I'm working on, to get data from the Source sheet I want to reference the cells in the following manner:

A1 = Source!A1
B1 = Source!C1
C1 = Source!E1

And then I want to use the Fill handle to automatically have D1=Source!G1, E1=Source!I1 and so on.

But when I select A1, B1 and C1 and drag right, the reference is getting mixed up and showing some cells twice.

Any help with this will be appreciated.
Thank you.

Try this formula in A1:

=INDEX(Source!$1:$1,(COLUMNS($A:A)-1)*2+1)

then copy across as required.

Hope this helps.

Pete