The first step I would take is to get all of that data into one workbook. You can use a simple formula to link to the desired data. Then, fill the formula down to the last row you need. then, the formula will need to change based on the name & tab of the next file. This is easier since they are numerical and same tab names.
You could use VBA to loop through the workbooks (changing the filename after X rows have been copied).