See sample code on Ron de Bruin's site:

http://www.rondebruin.nl/

"Tom" wrote:

I need to combine multiple sheets into one sheet so I can sort them all at
one time. I have a workbook I received from another person. Instead of just
having one worksheet, it has many worksheets, each a continuation of the one
before it. If it were only a few sheets I could just copy each sheet and
paste it onto the bottom of the first sheet. Is there a way of combining all
of these sheets?