Automated Point Removal For Perfect Attendance

Hi everyone, I am very much a newbie, and could use some help. I am putting together an attendance tracker for where I work. I have included a sample spreadsheet to show what I'm talking about. Each month is a separate sheet. In my sample February is how attendance used to be tracked and March is how I want to track it. Doing it the old way everyone's points had to be added up manually. I have made it automated so that when I add a 'U', 'E', or whatever letter applies it will automatically total up how many points that person has. I even have the total point column set up to add the points from the previous month. So far everything is working exactly as intended, but this is where things get tricky. We have a policy in place that if an employee has 30 consecutive days of perfect attendance we will remove one point from their record. I know that nobody is going to manually count how many days each employee has come to work in a row, so this, more than anything else, needs to be automated. The red cells AJ9, AJ10, and AJ11 show the current formula I am using. It is looking at a range of cells for each employee in March. If there are 25 consecutive cells with no data in them it will display a 1 and if the employee did not have 25 days of perfect attendance it will display 0. That amount will then be subtracted from the employees total points. This would work fine if the employee had to have perfect attendance for a calendar month, but that's not the case. The 30 consecutive days can start one month and finish the next, which means this formula needs to be able to do the same. I can not figure out how to make it look at a range of cells consisting of multiple ranges across multiple sheets. To be exact, in this sample I want cell AJ9 in March to look at February B9 through Z9 and March B9 through AC9 and if there are 30 consecutive cells with no data it should add 1 to March AJ9. I have been looking for an answer to this problem for a while now and any help at all would be greatly appreciated by both myself and my employees. Thanks.

A user in another forum suggested I put the entire year into a single sheet rather than separate the months. While this does accomplish the end goal, it does not do it the way I originally intended. I'm fairly confident there is a way to do what I wanted and I'm very curious to see the solution. With that in mind I am leaving this thread open for the time being, even though I plan on using the single sheet method personally. I will mark this thread solved in about a day.