You want to sort data automatically? The sort key may be a number or a text? There might even be duplicates? And you are not allowed to use macros?
Here you go: [If you look for a simple VBA solution, go here, please.]
1. Unsorted input data in sheet 'Unsorted':