Create new list based on data from another dynamic list

Hi, and thanks for your time. Hope the title sort of makes sense.
I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.

Any help would be much appreciated.

Many thanks