Trying to extract data from one sheet to another

[Michelle2175]

Hello there!

Please see my attached example spreadsheet. I am trying to extract data from the "Master List" sheet into the "Soccer" sheet.

I would like the Name, Age, Sport, Jersey Colour and Date Played to automatically populate into the "Soccer" sheet for all the kids who play soccer.

I know I could autofilter the "Master Sheet" and then copy and paste the data into the a new sheet but I would like to know if this could happen automatically... even as I put more entries into my "Master List".

Thanks in advanced!
Michelle