complex formula for gathering Monthly data

Originally Posted by Kram222

In my attached woorkbook there is a overtime sheet. the sum of all of the face hours for the said month would be entered in there, accordingly.

I only see 6 worksheets.

1242
1243
1244
1245
Utility
Monthly Hours

There is no overtime worksheet.