Summing across multiple worksheets

Ah yes, I see that Machine 13 has its corresponding data in row 361. What you can do is insert blank rows in the other sheets so that they all present their data on the same row (i.e. 361) (you can hide the blank rows, so the sheets will still look the same as they do now).

Hope this helps.

Pete

Great tip from me as well, for anyone else reading through this thread, just make sure you capitalize the Begin:End.
Couldn't figure out why it wouldn't work as you said it would until I corrected the spelling.
Thanks again.