The example below will copy from row 2 till the last row with data on each sheet Change the start row in the macro if you want to start in a different row.
'Fill in the start row Sub Copy Data Without Headers() Dim sh As Worksheet Dim Dest Sh As Worksheet Dim Last As Long Dim sh Last As Long Dim Copy Rng As Range Dim Start Row As Long With Application .
The Open Files Add-In successfully allows me to aggregate the various Workbook's worksheets into a single workbook. Unfortunately the linked macro is not editable so I couldn't use it to guide me.
However the tabs are not named from the name of the original file. In this case a coworker was able to get me started and I further modified it to meet my needs.
Copy the code in a Standard module of your workbook, if you just started with VBA see this page.