Keeping ALL macros in Personal.xlsb ?

You could export all your modules from your sheets - maybe using something like this from Ron de Bruin

https://www.rondebruin.nl/win/s9/win002.htm

Then you can try this tool for managing a vba library.
Import them all into this and see if it helps manage where there are duplicates and delete them as needed.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1054