Hello,
  My problem is :

1. i have one workbook in that there is a worksheet named Mapping which i will write according to my need as follows and also run macro with this excel file to generate a worksheet Data with columns name marked with *:

........Input........ -------------output--------------
D4 Project info > D Data Unit name*(output file column name)
D7 Project info > E Data Project name*
G8 Effort info > F Data ProjectID*
H8 Project detail G Data effectiveness*
This table can as long as possible

1. Input files are many and have many worksheet.
2. output file "any name" that has worksheet named "Data" will be consist columns marked with * .
3.when i click a button through my mapping file a worksheet named Data will generate automatically and has columns names marked with *.
4. After generating worksheet named "Data" copy data from
   many source files.

    for e.g
    WorkbookName.projectinfo.D4 copy WorkbookName.Data.D.Unitname
     WorkbookName.projectinfo.D7 copy WorkbookName.Data.E.projectname
      WorkbookName2.Effortinfo.G8 copy WorkbookName.Data.F.ProjectID
  and so on
Please help me in writing this macro.