Yes it is possible.
Initialize a variable(finalsheet) that points to the Final sheet.
Initialize a variable (worksheetcount) and set it to 0.
Now, loop a FOR EACH worksheet and set your worksheetcount
Now, you can select the sheet by an INDEX(worksheetcount).
Count the number of rows in the sheet, and set another variable (numberofrows).
Do another loop from 1 to the NUMBEROFROWS, and select the NUMBEROFROWS row. Copy the value.
Select the finalsheet, and find the next available row (use the same method as the prvious count row loop).
Paste the selection into the finalsheet.
Now select the worksheet that you were working on by the INDEX(worksheetcount).
Loop the second for statment.
Now loop the first FOR.
VIOLA. It is that simple. It can be done!