Transpose column skip from different sheets

Greetings (i started studying excel not so long ago so please be patient), i'll get straight to the point: i have this excel file divided in different sheets; i need to take this numbers from sheet "M058" to the sheet "Summary". I used =transpose('M058'!D$14:D$17) i need to take vertical columns and make them horizontal. The problem is, when i "drag" the command in the adjacent 4 cells it skips several letters until it reaches G, how can i avoid this?