I have 3 worksheets (different resources) which all contain 2 to 4 columns
listing the grade level that each of that households child attends.

Example Columns: Name, Address, email, Grade (this may have 2-4 columns
depending on how many children, one may be in pre-k, one in 2nd and so on)

Name, Address, Grade (this could be 2-4 columns)
Jones, 777 Oates, (column 1) -pk, (column 2)- 3rd, (column3)- 6th

I need to pull from these worksheets by grade. A family may appear in more
than one grade list if they have more than one child. What is the best way to
pull this data?

I tried to filter the columns but when I do it will only give me one column
at a time in each worksheet. When I pull from the list say I want all 6th
graders it will only give me those in the 3rd column but not column 1 and 2.
What am I doing wrong?