Have a look on Youtube for some Excel Pivot table tutorials. I think your sorting filtering requirements should be solved by that.

Once you have that compiled onto a single Pivot Table, the coding can be much more straightforward to stick it in Word

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia