Sorting Work Sheets? How?

[mrchaos101]

I have a bunch of work sheets, each with a persons last name.

Is there a way to sort all the work sheets into ABC order?:confused

 

[Bernie Deitrick]

Mr. Chaos,

You have the last name on the sheet tab, or within a cell on the sheet?

HTH,
Bernie
MS Excel MVP

 

[DDM]

MrChaos, take a look at this page from David McRitchie's Website:
http://www.mvps.org/dmcritchie/excel/code/buildtoc.txt (specifically the
SortSheets macro about a third of the way down the page).