Thanks in advance for any help. I have multiple Excel Workbooks (same directory). I need to send the info from the first sheet (Sheet1) in each of these Workbooks to a single sheet in a new Workbook. I know how to copy the sheets and I have a macro to merge once the sheets are copied. But I would like to have a macro that would just merge the sheets without copying first.