The forms you are using are not very well suited for retrieving information.

The use of merged cells for example makes things difficult (avoid merged cells at all costs except for cosmetic purposes - If necessary format as " Center across selection" is a better approach). It is also not easy to pull the Term.

If possible, it would be easier to build a table with various columns - Student's name - Term - Date, etc...

You then could enter data using a simple userform ( as described here for example)

It would then be quite easy to retrieve information to analyze data. I know it's a big job, but once it's done, things will go very smooth.