To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Excel offers many filtering and sorting options, including color, specific text and alphabetical. So, if you have a "Last Name" column, you can alphabetize it in ascending or descending order ...

You don't have to add a header to every Excel worksheet individually when you can group them first.