Need Help With Multiplying & Adding Skipped Rows

[LokoMaty]

Hello, I need some help writing a function that will multiply 2 cells, several times and then add them at the end.

This is what I'm trying to reproduce

=[('Sheet 1'!$F6)*('Sheet 2'!B6)]+[('Sheet 1'!$K6)*('Sheet 2'!AM6)]

So as for Sheet 1, I am trying to go every 5 Columns to the right. And for Sheet 2, I am trying to go every 37 Columns to the right. I need to do this 53 times (52 weeks of the year + last week).

I have tried looking it up and I've seen some functions, but they add up every x number of rows, I am trying to multiply first and then sum up the total.

Can anyone help me out please and thank you.

[LokoMaty]

Still need help with this, is it not possible?

[LokoMaty]

Bump. Anyone?