Why does drag and drop not work in this case?

I want the sum of a calculation, that is shown at the end of the calculation also be seen on the separate sheet. Therefore, I used "=" for the fields in the second sheet. I don’t want to fill all 100 fields in by hand so I am trying to use the normally simple drag and drop option of Excel to fill the plancs in automatically. Yet, Excel won’t fill the fields in.
Fields 1 and two are: "=Calculation!C39" and "=Calculation!D39".

Why doesn’t it automatically fill the following ones with E39, F39 and so on?

Thank you!