Excel automations

I am trying to figure out if there is a way to automate grand totals that are autofiltered and then create a PDF report of it.

Background: I oversee a small continuing education program for about 200 students. I put their class attendance info. (including dates, hours earned, class names, etc.) into a worksheet that has the auto filters setup for each column so that I can filter by name, class, date, etc.). However, the next step is to provide a report to each of the 200 participants periodically, without having to manually (auto sum) total up the number of hours each person has earned and then create a PDF of it, which would take lots more time. Is there a solution out there that would automate those two things for me or at least one of them?

I've uploaded a sample file. Thanks!