Generating report from different excel files

Hi
I want help to create a macro to generate a report. Requirement is as follows…
In the attached zip file there are two folders input and output and one excel file as “Macro”. All of them will be pasted in Desktop. Input folder contains 3 file Automobile yyyymmdd, Helthcare yyyymmdd, Infrastructure yyyymmdd. They are downloaded from Sharepoint so each week yyyymmdd get changed. In output folder there is one excel file as “Masterdata” Now in “macro” excel file, input and output path is given and so as the file name of the excel files (except yyyymmdd). What the macro should do is it will open each file in the input folder (depending on the first part of the file name except yyyymmdd) and copy the content in each tab and paste it to respective tab in masterdata i.e. content of "region 1" tab of all (input) excel files will be pasted under "region 1" tab of “Masterdata” file. In the end it will save the Masterdata file.
Please let know if you need more info.

Give this a try. Change the input/output directory

Macro_v1.xlsm

@Abgijit2011

Your welcome. To give credit where credit is due the combinding of the array function comes from Chip Pearson and can be found at http://www.cpearson.com/excel/vbaarrays.htm.