Display needed info on different worksheet

I'm just new in using VBA, I created a simple problem that I can't figure out how to solve in worksheet 2, I have 3 worksheets.

1. Players - Complete info of players

2. Members - When I select the team name, I'd like to display the info First Name, Last Name and Team only for the team name I've chosen. This should automatically change whenever I select a team name.

3. Team Codes - Tables I used for my vlookup and drop down list.

I have attached my file for your reference.

Thank you very much!