The recommended setup for templates would be to store the master version of the templates on the network and have your IT group run scripts to copy these current templates onto the computers either at startup or on a regular (daily) schedule. If the script checks modified dates and only copies updates across then this isn't a big hit.

If your macros have not been updated for over 7 years then it is highly likely that >90% of them are never used by anyone in the organisation. It might be worth surveying the organisation to find out what macros are in use and focus your efforts on just those ones. If people aren't interested enough to let you know which macros they use then they won't miss them when you remove their access.

Sorting your macros into alphabetical groups is a novel approach. I would have thought they would be grouped by functionality. IF necessary to store these separate to the Normal.dotm then you make them available by loading the secondary templates as addins (either by placing in the startup folder or by using a macro in Normal to load/unload an addin).

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia