Auto transfer data from one work sheet to another

Hello,

I am fairly new to using Excel so please be patient with me!

I am putting together a recruitment log for my company and it requires a lot of information to be included about a lot of young people. I want to collate all this data on a "Master Sheet", but then have individuals information automatically copied to another sheet within the same workbook based upon the "Interest" which they have.

For example: Joe Blogg's information is all completed on the "Master" sheet. In the "Interest" column "Sport" is selected. I then want all of Joe's information to be copied to the worksheet named "Sport". I would like this to be done for the other options of interest to. Eventually I hope to have a "Master" sheet with all information required, and then several other sheets containing information of those that have the same interests.

I have attached an example (it is all fabricated for data protection purposes but should highlight what i mean)

I know it can be done through Macros or VB but as i said, limited knowledge! I appreciate any assistance with this!