Formula too long - too many sheet names

Hi all,

I have this crazy long formula that won't fit (I will need to make it longer also if possible) in a cell - I get the error "Formula is too long". I have read that I should reference/link the sheet names on another sheet or in 'helper' cells, but I am unsure of how to do this...any help would be appreciated. Workbook attached - TIA

Also - I am very reluctant to change the names of the sheets because they are referenced in several other workbooks....

Formula:

Please Login or Register  to view this content.

Yes, my apologies - it is quite complicated. This is payroll workbook to track/report on over-time hours. There are 2 types of sheets:
1. Sheets that look like smaller grids with days/dates are entry sheets - data entry personnel will enter the number of hours worked, followed by a code (these codes are shown on row 3 of the tracking sheets). Additionally, there may be more than one entry per day (making the formula longer) as well as a code may be tacked on to the end to indicate that the entry is 'late' (this is referenced in the formula by "P#", telling the formula to look to all/other dates to find that code for that pay period - again, making the formula loner again)
2. Tracking sheets - these sheets separate and pull the number of hours from the entry sheets (this is where the formula is used). Basically, the formula is saying....go to the data entry sheet, look at this range of cells, and look for the code referenced in row 3, if you find that code, sum all of the number of hours together for that code - then look at this other range of cells and look for the code "P1", meaning it is entered in a different range because it was late, but needs to be counted in this pay period.

Whew! Hope this clarifies it a bit...