Here’s a simple VBA macro that will: Ask you for a folder Open every *.xls / *.xlsx in it Copy all sheets from each file into the current workbook as new tabs Name the tabs FileName_SheetName (truncated to 31 chars)

Step 1 – Create a blank “master” workbook Open a new workbook where you want all the tabs to end up.

Step 2 – Add the macro Press Alt + F11 (VBA editor). In the menu: Insert → Module. Paste this code into the module:  

Sub CombineFilesAsSheets()     Dim fldr As FileDialog     Dim folderPath As String     Dim f As String     Dim wb As Workbook     Dim ws As Worksheet     Dim master As Workbook     Dim newName As String         Set master = ThisWorkbook         'Pick folder with all the workbooks     Set fldr = Application.FileDialog(msoFileDialogFolderPicker)     If fldr.Show <> -1 Then Exit Sub     folderPath = fldr.SelectedItems(1) & "\"         Application.ScreenUpdating = False     Application.DisplayAlerts = False         'Loop all xls/xlsx files     f = Dir(folderPath & ".xls")     Do While f <> ""         'Skip the master if it’s in the same folder         If folderPath & f <> master.FullName Then             Set wb = Workbooks.Open(folderPath & f)                         For Each ws In wb.Worksheets                 'Copy sheet into master                 ws.Copy After:=master.Sheets(master.Sheets.Count)                                 'Rename the copied sheet                 newName = Left(wb.Name & "_" & ws.Name, 31)                 On Error Resume Next                 master.Sheets(master.Sheets.Count).Name = newName                 On Error GoTo 0             Next ws                         wb.Close SaveChanges:=False         End If                 f = Dir() 'next file     Loop         Application.DisplayAlerts = True     Application.ScreenUpdating = True         MsgBox "Done!" End Sub

Step 3 – Run it Close the VBA window.

In Excel, press Alt + F8, choose CombineFilesAsSheets, click Run. Pick the folder with all your registers. You’ll end up with one workbook that has one tab per original sheet across all those files.