Merging multiple workbooks that contain identical tabs

Hi Glurby, welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

========
WORKBOOKS W/MULTIPLE SHEETS MERGED INTO SHEETS IN CONSOLIDATION WORKBOOK

Meanwhile, here's a macro for collecting data from all sheets in all files in a specific folder merging into matching sheets.

Workbooks to Sheets - Part 4

You will want to edit the fPath variable to your folder, or insert your own method of "selecting a folder".

You'll also want to edit this one line of code to copy from row6 on....

.Range("A6:A" & LR).EntireRow.Copy wsMain.Range("A" & NR)

Slip that macro into a "master" workbook with all your sheet tabs laid out.