College Credit Template - calculating the # of class type with course credits.

So I am trying to rework an excel template that I found for calculating college credit courses etc.
Currently the one I have includes 12 Semesters but I don’t know how to extract 2 tabs from it so I am posting the original Template for my questions.

1. How do I get the fields d6 thru d9 to reflect the count of “Academic Major, Minor, General & Electives” shown in column c below then add up the number in column D next to each one?
2. A friend of mine helped me modify the document to get a few other things tweaked. For example my version shows 12 semesters now, so when we went into the code on a screen share his version of excel (pc) he has an update data or update spreadsheet & on mine (mac) that update button isn’t there. Where would I find this update button in mac?

YES !!!!

Skywriter that was the goal, THANKS!!!!!

glad to give out a few points, side question, does anyone have an online sheet for managing their forums?