Consider it done. We have ready made solutions for data consolidation/merging (from different sources), deduplication, manipulation and presenting outputs in a "nice and sexy" way (be it Excel, Word, Powerpoint) or csv or a complex xml structure. Please provide us with a sample and more precise requirements.