As for separating by units, since each inmate can only have one unit (I presume), that could easily be handled on the same sheet by adding a field for unit and filtering. I know you want separate sheets for this but I only suggest this because I'm a stickler for avoiding data duplication.

However, I'm not sure that is the case for your staffing situation. Would each inmate have many staff? If that's the case, then I think you are forced to use multiple sheets. That in turn would, I think, need code, if it can be done at all in Excel. If you prefer to go that route, maybe repost in the programming section. My VBA skills are rusty and were more with Access any way.

And, speaking of Access, if it is a many-to-many relationship, a relational database might be a better platform, though I know Access has fallen out of favor of late.

However, if there's any chance you think the one sheet/filtering option might work, I'll be glad to help.