The next method is to copy or move one or several Excel sheets manually to another file.
Therefore, open both Excel workbooks: The file containing the worksheets which you want to merge (the source workbook) and the new one, which should comprise all the worksheets from the separate files.
Step 2: Ensure the data is organized in the same way (see example below).Sub merge Files() 'Merges all files in a folder to a main file. 'Define variables: Dim number Of Files Chosen, i As Integer Dim temp File Dialog As file Dialog Dim main Workbook, source Workbook As Workbook Dim temp Work Sheet As Worksheet Set main Workbook = Application. You build your file and cell reference with the INDIRECT formula. With the INDIRECT formula you can link to other files.That way, the original files remain and the INDIRECT formula only looks up the values within these files. Only condition: the source file must be open in the background. On the left hand side: The main/ combined workbook. Count) Next temp Work Sheet 'Close the source workbook source Workbook.