How to write all excel sheets data into one excel sheet

[Gokul001 (Gokul Balaji)]

Just watch over this thread too @Sindhu_Priya

Combine Excel Sheets Into 1 New Excel File

Hi all, 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): [image] 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): [image] I’ve tried doing this with Merge Dat…