Assume that you have 100 sheets in an Xcel workbook which each has 10 rows of
data and you want 1 sheet with 1000 rows of data, what is the easiest way to
do it?

Is there an easier way to do it than cutting and pasting 99 times?