Thank you for letting me know.As far as I know, you cannot change the order.
The list should be sorted in alpha order for named ranges followed by tables which are in the order they appear in the workbook
I agree. It makes a big difference.Personally, I like to test my solutions with real data. I don't like creating data to test as it may not be in the same form as yours.