I need help with formula. I have my scheduling on excel and I have it set
like this:

A B C D E F G

ID# Name RGY S/D Zone

In the zone column it states number 1-8

I have three sheets set up like this, 15 codes, 16 17 codes, 18 codes. Based
on how old the people are.

I want to list on a separate Sheet in order all those (Names) that are
scheduled in zone 1 and if possible alphabetically.

Any help would be appreciated.