Hi,

I know that merging multiple workbooks in the same folder into one is a common question, but my problem is that all my workbooks have the same sheet name ("Template"). So when I use the code below, it copies over them....can someone help me with this? I don't care what the new sheet names are, I just need to get them all into one workbook so I can extract data from them. The worksheets are all identical.

Please Login or Register  to view this content.