Merge data from multiple sheet into one sheet

Hello Friends,

I have 5 sheets in folder and i want to merge/copy data from all these sheets into one sheet.

Please help me on this. And I need to do this using STUDIO X

Thank you.

Hi, I do this to merge all sheets.
First, are they the same size, or they are the full sheet?
if yes, then just make for every row in each sheet (you can make another every row with sheet names to make the robot go throght every sheet) you Add a row on the sheet you are merging, on row 2:2. than append current row.
That should work.
if you don`t have every sheet of the same size just use the biggest range.