Collecting data from filled cells and skipping blank cells

Hi KellieB and welcome to the forum,

I would not do a sheet per student. See the attached with a table that can be AutoFiltered for any date or standard or class you want. Then a pivot table (I've done a simple example) can be made to display what you want.

See if this gives you some other ideas on how to do this problem.