Macro to copy data from multiple workbooks and sheets

[Rajan_Verma]

You can visit here to have a code to accomplish this task

Split Data into Multiple Workbook « excelpoweruser

Thanks
Rajan verma