There are four classes, let's say Match, Science, English & Geogrpahy.
In this workbook, there are two sheets: "Summary" and "Entry"

The student would enter classes of all kinds on the "Entry" page, but I
would like for the four classes above to copy automatically into the
next blank cell in a specific range on the "Summary" page.

The entry range would be Sheets("Entry").Range("C6:C104")
The summary range would be Sheets("Summary").Range("A34:A49")

Two questions about this:
1. Can this be done with an in-cell formula without a macro?
2. If not #1, then what kind of code would be needed to just copy the
cell contents and not the whole cell, formatting and all?

thanks to all