Merge and Combine Worksheets from Multiple Workbooks

Dealing with situations where one need to combine and merge multiple workbooks into one sheet, there is an extremely useful RDBmerge ADD-IN by MVP RON DE BRUIN.

The tool is free and is very robust and powerful enough to handle most if not all the different kind of situational requirements.

However, if you are just looking for a quick simple tool for merging and combining sheets structured in the same format from multiple workbooks, I have attached a template below for that purpose. The original macro is from Contextures (which I edited slightly 1) To fill up any blanks in between rows in the source files & 2) to include a "source" column to identify which workbook those records originated from.)

For the merging of files which may contain different number of fields, perhaps this other post is more applicable: Merge and combine common fields selected from multiple Workbooks

Click on CreateTable

Type the name of worksheet you intend to combine

Select all the files you want to combine

Download File

PS: For compiling files which have different number of columns, kindly refer to Part 2:  Merge and combine common fields selected from multiple Workbooks