Excel Sheets

[jai prakash]

I have a hundred sheets in one single excel file, which is
named unidentically... say Apple, Orange, Pineapple etc.

Now, I am manually placing them in order of their names...
i mean ascending / decending order...

Kindly help me to get the command at a stretch to sort the
name of the sub-files.

 

[Peo Sjoblom]

You need VBA to do that, example here

http://www.cpearson.com/excel/sortws.htm