I have a spreadsheet in which I'd like to be able to sort several
columns at different times (depending on what info I'm interested
in). Is there a way I could get excel to automatically sort the data
based on a selection I make from a drop down?

Example:
A1:A10 are names. B1:B10 are their hours worked. C1:C10 is their
output. D1:D10 is their hourly wage. I'd like a cell (say E1) to be
a drop down with three different options: 'hours worked', 'output',
and 'hourly wage.' Based on which of those three I select, the entire
data set would be sorted based on that criteria.

Can anyone help??

Thanks!

-ADH