I have an Excel Workbook with multiple sheets (amount of sheets & sheet names will vary each time). the structure of each sheet is the same (Same 4 columns, just different data):
What I’m trying to do is combine all of these sheets into 1 new Excel Workbook on 1 sheet, with just the headers at the top, and all of the data. So I want each sheet’s data to be copied below the last row on each sheet (no line breaks or spaces between):
I’ve tried doing this with Merge DataTable and Append DataTable, but no luck so far. Any suggestions would be appreciated!