combining worksheets

[Guest]

How can I combine all worksheets into one while keeping the same columns in the the same order? The worksheets are all set up identically, but I need to combine all the info into one worksheet so that I can alphabeticalize the data
Thanks

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/copy2.htm

-----Original Message-----
How can I combine all worksheets into one while keeping

the same columns in the the same order? The worksheets are
all set up identically, but I need to combine all the info
into one worksheet so that I can alphabeticalize the data.