Just looking through some unanswered posts and came across this one...If you still need help with this I think I have a way!...
In this link Sheet Swap with Action Filters...the simple version!
There is a trick to allow you to swap sheets on an action filter. So if you set up one sheet sorted ascending, another descending and then use the sheet-swap trick to show/hide the one you want that should do it. If you look at the last example I posted there, it shows you how to trigger different swaps from different sheets.
Let me know if you have any problems.