Procedure Too Large

So I work at a hotel and have written a relatively simple spreadsheet for assigning rooms to housekeeping (our software has a terrible interface for it).

Anyway, the spreadsheet was working perfectly until we hired an additional housekeeper and I had to add additional code to include her. Problem is that now I'm getting a "Procedure Too Large" error. And it makes perfect sense. I definitely programmed this the LONG way, but I'm still trying to learn the more advanced code that would probably solve this issue.

Anyway, hopefully someone can give me some pointers on what to do!