Building macro to split out ranges

So in the system I use accounts are set by 123-45678 format, the first 3 being the branch and the final 5 being the account. One of the more onerous tasks is to take a large base list of ranges and break it into pieces, example:
168-00000 to 168-99999
610-25000 to 610-29999
611-80000 to 611-89999
752-05000 to 752-14999
752-20000 to 752-24999
791-00000 to 791-18999
791-66000 to 791-66499
791-90000 to 791-94999


Against this list I receive a set of ranges that I am told must either be added to the above list, or removed from the above list, example of remove:
168-00000 to 168-25000
791-92000 to 791-93000


Often the lists are much larger and take a considerable amount of time to manually adjust and this leaves much room for error. Ideally I am looking to design a macro in excel that I can input in one table the base list and then in another table the add/remove list, then run the macro which will combine or remove the ranges depending on the request.

I have written only 4-5 small macros and I am a bit lost as to where to start on this one, would anyone have any advice?

Thanks!

can you provide a specific example workbook to look at? (with an example of the Base list and Add /Remove list)

Sounds like a fun one though, would like to help

I attached a sample set with just the basics.