I need to clarify some things. When you say 12 folders do you mean you have 12 folders on your computer with 2 or more WORKBOOKS in them that you want to merge into 1 worksheet? Or do you have 12 Workbooks with 2 worksheets each that you want to merge into 1 worksheet.

Both are possible and just require some amount of code to do it.

If it is folders then I will need the address of where all the folders are in and if there are multiple files in those folders that are not Excel books I will need the Excel book names.

Just so you know this will most likely be a long process to get you a code that works since all of the needed information to get it right the first time is on YOUR computer. I am happy to help no matter what but I just want you to be prepared for that.