Macro to consolidate the data from mutliple files using Vlookup / Match

Hello,

I am looking for a Macro to copy the data from multiple excel files to single file.

Here it goes:

I have mutiple excel files in one location named as DownTime3_6_2012_1_23 (File saved at 1:23 on 3/6/2012), DownTime3_5_2012_14_21, and so on.......... Now I want the Macro to create a consolidated report which will already have the server list updated in Column A of result file (ConsolidatedResult.xls) and it need to do the Vlookup/Match with the files and copy the data as per the attached sample file (ConsolidatedReport.xls).

Any help would be appreciated.

Regards,
Pradeep