Hi,

> Are there any elegant techniques available to do this apart from
> general ETL (Extract/Transfer/Load) methods to do this
> or is building the table manually my only forte

I'd settup a "cental" database to get replicated data from all other five.
This way you just need to query this db to get data from all sites. There
are many great replication tools out there.


Regards,
Anderson Farias