Merge Workbooks - Version 2.0 Merge Workbooks is an Excel macro that will combine several Excel workbooks into one workbook. The user selects the workbooks to merge and the macro copies all the worksheets in those workbooks into a new workbook. The trial version is limited to combining up to 5 workbooks.