It is certainly possible to do via code but seems like a lot of work to recreate so I would be wanting to start from your existing excel file.

Your Excel setup does seem overly complicated - why aren't you using a pivot table with filters and sorting to do the work of all your separate sheets?

Transferring content back to Word is easy enough. The styles can be applied via VBA as you move that content based on your rules.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia