Is it possible to reference a cell, but by moving that cells referenced cells one to the right?

I don't know how to explain this too well, so I will try my best.

I have multiple sheets at the moment and I want to try and speed up a process here.

On sheet 1, cell H2, I have a formula that uses the SUM of 17 different cells in column G of sheet 5. These 17 cells are not in order, so the formula reads

=((Sheet5!G33+Sheet5!J35+...15 more)/17)*0.8

Now, on sheet 2 I want to use those same 17 rows, but in column H on Sheet 5, not column G. Is there a way to streamline what I'm trying to do or do I have to do it all manually again?

I thought I'd be able to say on sheet 2 that F2 = (Sheet1H2....but with those 17 in that sum moved one column to the right)

I really hope this makes sense. If it doesn't, I can try to explain it better in the comments or via DM.

TIA.