how to make a macor for calculating values

It's been quite a while for me to work in Excel, which is why I'm writing here...
I need to make a macro that'll total data in a row, go down a few more rows, total data in this next row, go down a few more and so on. Next, I need the macro to go to a second worksheet and do the same thing. After that, I need the macro to go to a third sheet and then take the newly computed totals from the previous worksheets and total them up on this third sheet.

I am looking for format of this macro more than anything at the moment and am just not sure of how to switch fro row to row or from sheet to sheet.

If anyone can help a geek with senility, I sure would appreciate it. Thanks so much in advance! Looking forward to your replies!

Hello greaseman,

You don't provide any details about your data format other than it is in a row and on a worksheet. It would help if you can post your workbook along with notes about the data.

Thanks,
Leith Ross