Hello,
It can be done as an Excel VBA application. I will do that in no more than 2 days. I will need samples for each of the sheets the application has to read from, and more details on the format of the summary, if you have an idea on that.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA for 12+ years. As you can guess, I have created a plethora of such applications and summaries, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
chriskerpini