Aggregating Data with Word

[Brilstern]

I am looking to create a "roll-up" report in MS Word by aggregating data from tables within 5 other reports. I have looked at a lot of different concepts but would like some input from the bytes community. Considerations include using VBA to import data from the individual reports to combined tables in one report, using PowerShell to aggregate the data and export as an html document, and implementing MS Access in some form or fashion. Some data-sets are below for examples. I am not looking for a direct answer, just need some help putting an idea into action.

Individual Reports
Tables (4)
Table 1 // 1 Label/Value
Table 2 // 3 Label/Value
Table 3 // 2 Label, Multiple Values
Table 4 // 3 Label, Multiple Values

Table 1
(Total Host Count, 100)

Table 2
{Severity, Count}
(High, 23)
(Med, 67)
(Low, 34)

Table 3
{Operating System, Count}
(Windows, 68)
(CISCO IOS, 12)
(VMware, 5)
(Linux, 15)

Table 4
{IP Address, Name, Score}
(192.168.1.2, PC1, 100)
(192.168.1.12, PC2, 78)
(192.168.1.23, PC3, 76)
(192.168.1.34, PC4, 58)
(192.168.1.45, PC5, 46)

For Tables like 1 and 2 I would be looking to combine the data and create summary tables.

For 3 a Summary table would be ideal but I need to include variables results, as it is not a set table.

For 4 I need to combine all the data and only keep the top 50.

Not really sure where to go/just need some pointers, thanks!

-SB

**Note, all 5 reports have identical formats, I essentially need to iterate through each one and grab the data for one BIG report.

[Brilstern]

Ok, I have decided on a method and solution.

Import Word doc into MS Access. Manage and aggregate everything through Access. Export into Word for final report. If anyone wants to know more about how I accomplished this please let me know.

-SB