Dragging a formula into consecutive columns that skip columns they are referencing

Hi there,

I'm trying to do something that I'm sure is straight forward but it's proving difficult.

I'm creating a summary sheet that captures the revenue for each year, so references a different sheet (Revenues) every 12 columns (12 months).

What I'd like to have is a formula that as I drag it gives me

D7 = 'Revenues'!P11
E7 = 'Revenues'!AB11
F7 = 'Revenues'!AN11
G7 = 'Revenues'!AZ11

but obviously it gives me

D7 = 'Revenues'!P11
E7 = 'Revenues'!Q11
F7 = 'Revenues'!R11
G7 = 'Revenues'!S11

I've seen other things on the forum but none make it clear enough what I need to do.

Thank you in advance!!

Amazing. Thank you. Am going through it now to work out exactly why it works but at least it does.

Thank you!