How do I fix 14 tables at Once? Attendance Report needing to remove termed employees

I have an attendance report I’ve been trying to perfect over the last 6 months, but I’ve run into a road block.
I use a macro to add new employees and sort them without affecting the current data, but I can’t seem to find a way to remove employees without a lot of work. It would be most ideal to select all tabs and then simply delete the terminated employee from all tables at once. But Excel won’t allow me to do that.

I tried highlighting all of the terminated employee rows and then used a macro to move them to the bottom of the table and then delete them one tab at a time. It worked fine, but then I had to continually add new rows to each table, otherwise the macro wouldn’t catch them all after a while.
I’m trying to make this user friendly so that other people (who might not know Excel) could use this report. I don’t think many people will spend the time to add new rows to 14 tables….sooo, I need a fix.
Any suggestions on how to accomplish getting the terminated employees off of 14 tables at once? OR any suggestions on how to do this whole process better?


I’ve slowly taught myself Excel by reading forums just like this one and I’m always looking for a better way!
I am attaching a copy of the report, so do your magic!

Thank you Alansidman. I appreciate your response, but I'm still a little new.
Do I input this code as a new module? And how do I get it to run?

Oh My Gosh, you are a lifesaver!
Thank you so much for this fix. This will make my life so much easier.