Transfer data from master sheet to different sheets.

I have a master worksheet with a list of students and their corresponding scores for each test they have taken. Each student may have multiple scores for each test depending on the number of test they have taken. Column A is the list of names; Column B the date the test was taken, Column C the scores and Column D the type of test.

So what I want to do is to split the data from this master worksheet into multiple worksheets depending on the type of test they have taken. On the sheets were the data will be transferred the name of the students will only appear once under column A, and their corresponding will appear horizontally after the name. A student can have up to 25 test scores for each type of test.

Can this be done by formulas/functions or only through macro? Please see attached sample worksheet. Thanks!