Hi Sue,
Please write out the question -- even if it matches the subject.
Wastes other people's time trying to find out if there is a question or not,
whether the posting has loaded or not. An actual first/lastname is
a lot more friendly and would help you find your messages and
previous answers in Google Groups search.

You will need a macro
Sort All Sheets
http://www.mvps.org/dmcritchie/excel...#sortallsheets.

If not familiar with macros, a link is at the top of the page, but you
can go directly to
http://www.mvps.org/dmcritchie/excel....htm#havemacro

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sue" wrote in message ...