Hello, I have two worksheets in this workbook. One worksheet has the names of
students that I have, what classses they are in, and their contact
information. The second worksheet has the names of the students that I have,
the tests they took, and all the answers they gave for each test.

A Hypothetical Example:

Worksheet 1:

Jerry Economics Classroom #104
Jimmy Finance Classroom #104
Natalie Economics Classroom #334
Amy Finance Classroom #104

Worksheet 2:

Jerry Test #1 Question 1: A
Question 2: A (...)
Jimmy Test #1 Question 1: C
Question 2: B (...)
Natalie Test #2 Question 1: B
Question 2: C (...)
Amy Test #1 Question 1: A
Question 2: C (...)

So, what I want to do is pull down the list in Worksheet 1 that has what
class they are taking and filter out only those students who are taking
Economics and somehow link that action to Worksheet two. So, that when I
move over to Worksheet 2 it will only display the test answers to the
students in my Economics class.