Thank you so much!!!! This is exactly what I needed. I have a question. I have to do this hundreds of times. Do I have to do step 1 each time or will step 2 save me from that. Example I have 300 regions, each region has multiple workbooks that I have to combine into one master workbook so that I can send it to that regional manager. So in the end I should have 300 master workbooks, each workbook would have the combined workbooks for that region. Would I have to do the VBA macro each time or could I use step two to run the macro and just select the next batch of files. I appreciate your assistance!!!!!

Hi Jeff, really useful code but when I try it it fails. I have a folder with 2 files in it. When I run the code it opens a new workbook and copies in the sheet from the first file in the folder. It then opens the second file but then gives and error message saying Method 'Copy' of object '_Worksheet' failed. When I debug it highlights the following in the code: ' Loop through each worksheet in Workbook For Each ws In wbSource.Worksheets ws.Copy After:=wbDest.Sheets(wbDest.Sheets.Count) Next ws Any ideas?

Thank you so much for the insightful video! Is there a way to define the xls import file order?