in one case, we have a customer with over 1000 modules
Ouch!!
I would have to have a firm understanding of all the nuances to even take a stab at developing a solution for this if possible at all. Not really an issue that can be answered in this forum environment in a few responses to your questions.

There is the commercial help area on this forum for things like this.