Thanks GC Excel, I looked at it and I think I understand what you have done, but I am not actually seeing the "E", "T" or "NC" showing up on the EMER tab.
When I look at the code, I can see you referenced columns 1, 7 and 10, which is the Name, Date and Status (status is what should show on the EMER tab). I understand I will need to make one for each month, I can do that.
On the "write back to sheet" portion of the code I can see you are using lines 23-32, which you added names to. This part confuses me a bit, but I think I can see what it is doing.

Unfortunately, I do not see it writing back to the EMER tab.