1. Do you want to copy Sheet2 from each workbook and post it in a destination workbook as Sheet1, Sheet2, Sheet3 etc.,?
2. Or .. do you want to copy the data that is available in Sheet2 from each workbook and post it in a destination workbook in one CombinedDataSheet one below the other?