I am trying to create an excel spreadsheet that allows me to update students' names on the list of a seminar date. Here is what I want to do:

Sheet 1 = a master list of students with Column A "Student Name", Column B "Seminar Date"

Sheet 2 = the list for the seminar that occurs on 05/18/2017.

I want a formula that allows me to automatically update the list on Sheet 2. Every time, I type in "05/18/2017", on the "Seminar Date" column of Sheet 1, I would like that students' name to be automatically added to the list on Sheet 2.

Basically I want a formula that auto updates a list without needing to have that formula copied into each cell of the list...

I have done this in google sheets before using a query formula that allows for this sort of thing. For example, =Query(Sheet1!A2:B100, "select A where day B='18'",1)

How can I do this in Excel???

I know that there are alternatives to this but I need a formula that does exactly that (for reasons that are too complicated to explain in this post).