I use the cod Combine All Data From All Worksheets in All Workbooks in a Specified Directory, from this forum, and it is good. But I want to modify because I want to combine only Sheet1 from each Workbook. How can make do this?
I use the cod Combine All Data From All Worksheets in All Workbooks in a Specified Directory, from this forum, and it is good. But I want to modify because I want to combine only Sheet1 from each Workbook. How can make do this?