Automatic updating list of current members from table of all time members

I play a online roleplaying game and keep a list of all members ever in my faction. I have recently acquired a second faction and would like to have a list of current members in the first faction to allow me to select the member whose alternate character is in the second. I do use different workbooks for each faction. I have been able to create the data validation list of all members in the first faction from the first workbook to the second, but i want to have that list only show players whose line shows they are a member. I know that i could always use vlookup to do this but my issue with that is that it leaves blanks in the list and if i make the results a table of its own and sort then the original table sorts as well.

Can anyone help me with this issue?

*I am willing to use VBA if given the correct coding, as I am still learning it.