Create a roster from a "database" worksheet that excludes dismissed students

.
Paste the below macro into a Routine Module and call/run from a CommanButton on Sheet Primary (see attached):

Please Login or Register  to view this content.

The macro looks for an X in Col B. The X indicates the listed student is no longer in the Music Class. When found, that entire row is deleted. Then the
macro copies Sheet Primary to Sheet Semester beginning at Row 2.

All you need do in the future is place an X in the cell/row for the students no longer in class.

Hello TMarler and Welcome to Excel Forum.
As a compliment to the fine VBA solution Logit supplied, here is a formula based solution.
The array entered formula* that populates column A is:

Formula:

Please Login or Register  to view this content.

The formula that populates columns B:J is:

Formula:

Please Login or Register  to view this content.

Column G is formatted as Date.
Columns H:J have a conditional formatting rule applied that hides the zeros.
*Array entered formulas are activated by simultaneously pressing the Ctrl, Shift and Enter keys while the cell is in edit mode.
Let us know if you have any questions.

You can try with Pivot Table
if you update source, right click on Pivot Table and select Refresh

Thanks for the feedback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.