Vba code to copy data from multiple workbooks to single work book sheet wise : I want to copy data available in multiple worksheets in multiple workbooks into another workbook but sheet wise and data should have one coloumn of workbook name(from where it has been copied).
For example
Workbook1 name(Raju-can be any name) having 7 sheets with different name(sheet name are same in both workbook)
Workbook2 name(pappu-can be any name) having 7 sheets with different name

Copy in new workbook sheet wise ..in result workbook(first sheet should have all the data from first sheet of wkb 1 and wkb 2 and same thing for second sheet)...and in all the sheet workbook name should be there that from which workbook data is copied.