Consolidate multiple sheets from multiple excel files.!!!

[tamilarasu]

Community,

I have requirement to consolidate all excel sheets from multiple workbooks. I searched in forum and got some ideas but I have some problem in getting the desired result.

* My data is excel files and each excel consists 12 months of data and additional two sheets are for some analysis (sometimes they add additional sheets for analysis). I need to consolidate all months data (Eg; Jan'15 to Dec'15) from all excel files but should exclude the sheets.

* They added two columns in the year 2015 and they will add more based on the future needs . So it should pick the new headers too.

Snapshots:

2013 (Jan month):                                                                                        

  

2015 (Jan month) (Additional fields added)):

My out put should be like below:

Could anyone guide me or provide me the code?

The above screenshots are just mock data and attached the same.

[help4qv123]

Hey Tamil,

How r posting these images...its quite funny...can u tell me bro

[N_1]

Hi Tamil. Can you provide the code in some other format like text?? I am not able to view the file. Thanks!