But be aware, that you may not see the result as you expect.
It would be better, if you could first combine all of your data to a
single sheet (assuming your version of Excel can accommodate theta
number of rows).
For consolidating data from multiple sheets, take a look at http://www.rondebruin.nl/copy2.htm