Vba to advance filter data on multiple conditions to many sheets with naming convention

Hi,

I am a basic user of excel but heard about vba from peers to accomplish task quickly and unfortunately I don't have much knowledge about vba.

My question.
===========

I have raw data where I have Names of people and their grades for their subjects and I am in need of a vba code which will extract data from raw sheet based on their names and grade. (two criteria)

I have attached a sample sheet for better understanding.

Except rawdata sheets the other sheets are output sheets which are named based on names and grades, I hope that naming convention can also be addressed by vba

Note: The list of raw data can grow so I am wondering if we can make it dynamic.

Please help!!!

Thanks!


Hope someone will help.