Index and vlookup assistance
 

Hello,
I am trying to pull player names from a sourcebook to another workbook
using the team name in column E.
A B C......... E .... AA
1 Jones, Walt Lions
2 Doe, John Bulldogs
3 Jacobs, Bill Sentinels
4 Smith, Jane Lions
How can I use the team name to gather each player on a team in column A of
the destination book.
I appreciate any assistance.