Formula to be copied as per destination cells

Dear All,

When I'm copying the formula from one cell to another cell, cell reference is being changed as per source cells rather than destination cells which is making me to edit the formula every time

Ex: Case-1 which is happening right now: 1st Sum formula I've entered manually, so will see from next formula i.e., 2nd formula is Sheet1!E3 = SUM('Sheet2'!G3:G20), 3rd formula is Sheet1!H3=SUM('Sheet2'!J3:J20) etc

Case2 which should happen: But I want to populate formula as per destination cells i.e., 2nd formula is Sheet1!E3 = SUM('Sheet2'!F3:F20), 3rd formula is Sheet1!H3=SUM('Sheet2'!H3:H20) etc

I could do manually, but will consume lot of time and even eager to know whether it is possible

Is this possible? Please let me know and do the needful.