OK, I am looking for some macro programming.

In the Senior Tracking 1 Sheet, when I click the print records button, I want the macro to do the following things,
  1. Print page one of the sheet only
  2. Select the next name down in the list in cell B12
  3. Sort table by column A(subject)
  4. Print Sheet 1 only

and repeat until all names in the list (b12) have a record printed off for them.

Is this possible?

Thanks in advance for any help.
AlasdairPrep Sheet 1.xlsx