Compare two workbooks and write Snapshot report for the differences!

[tcambridge6307]

Hi All,

I have two workbooks (example: ABC March14 Report and ABC April14 Report), which have indentical tabs names. I want to run a quick SnapShot one page report of the diffrences from March to April. Please see sample reports. Can you please help with VBA codes to do somthing like the following:


1- Import ABC March14 report (xls, xlsx, csv, xml, ...)
2- Import ABC April14 report (xls, xlsx, csv, xml,...)
3- Compare all worksheets between the two reports
4- Creating a new workbook call as "Snapshot Report From..(partial of the file names)" (March14 to April14)
5- Copy and paste all the rows and colums of differences (March14 vs. April14) to the Snapshot Report

Greatly appreciate all your helps.