Automate Advanced Filter / VBA to split data to new spreadsheets

[Jasbels]

Hi I have scoured your site and many others but cannot find code that I can amend to fit my query, I can follow and create simple code but this is a bit past my capabilities.

Attached is an example of my spreadsheet, there are actually 425 rows.
What I would like is to create separate registers for each class in each group, there would be over 100 spreadsheets created.

I would like the new spreadsheets to look something like sheet2 onwards, of the attached, with the class name as the tab name.
I have some VBA code which, after tweaking the layout of my spreadsheet, will split the data
into separate sheets but I don't know how to amend the code to move to classB once column classA has been done then move to, classC and so on.

Also, I don't particularly want to have to amend the layout of the spreadsheet as I would also like
to be able to make alterations to the classes on the original and for this amendment to show on the
individual class register. Any help would be greatly appreciated.