This works great! ... there is one small error. When combining the tabs from workbooks 1-100, it combines the tabs by next column. This is great. However, when it copies to Target, it keeps this formatting. What would make this perfect is that I need to copy the information from the combined tab, and then append the data by next row in the Target workbook... This will allow my data to be represented in a massive table.

Thank you for your help