Autofill data troubleshooting - skipped cells

Hello all,

I'm having trouble autofilling data from skipped cells of another worksheet.
I copied the value from the first worksheet (='Vault Apr19-Aug23'!AU24) into the second one.
What I want to do is autofill the values, but the first worksheet contains the values in skipped cells. When I use the autofill drag feature, it reads the cells hich are directly beside it, for example...AU24, AV24, AW24....etc....
I really want it to read cells, AU24, AW24, AY24..(SKIP A CEL).

Please help me with this one guys. Its getting real frustraing, and I need the help.
Thx in advance guys.