Hello All I am new in doing macro in Excel 2003. I am asked to do a project by my supervisor where I need to copy data from three workbook and place those data in three worksheets of another workbook. For example if I have workbook 1, workbook 2, workbook3 and workbook4. All I need to do is copy all data of the sheet1 of workbook 1 and paste into sheet1 in workbook 4 and copy all data of the sheet1 of workbook 2 paste into sheet2 in workbook 4 and copy all data of the sheet1 of workbook 3 paste into sheet3 in workbook 4. I don't know how to do that. Can anyone help me out regarding this? I badly need help for this. Any help would be appreciated. Mili
