OK, I have slightly modified the VBA code in the Requirements subform and I think it now does what you want, try it out and see what you think.
As to the append queries, that can either be handled by a no duplicates field or we can add some VBA to wherever you add the Employee to either run the similar queries for just that added employee or use VBA code to do the update.