Copy and Paste specific columns with VBA

[DianaMomOf5]

I am pretty new to VBA and stuck. I am trying to create a roster of people looking at a sheet with all people in it for a year. I want to be able to build a macro that will pull certain columns from the large dataset for every row that meets a data criteria. I want to be able to have the macro reference a cell for the date criteria so that a user can change the date and then run the macro to pull the roster data for the date entered into a reference cell. Is that possible? All the videos I see only hardcode in a criteria for cut/paste...

 

[My Aswer Is This]

Ok. So user enters "Cat" in range("A1") of sheet named "Alpha"
Now lets search column B of sheet named "Bravo" for the value "Cat"

And what do we do with the rows that have "Cat" in column "B"

Please provide specific details like this:

 

[DianaMomOf5]

Ok. So user enters "Cat" in range("A1") of sheet named "Alpha"
Now lets search column B of sheet named "Bravo" for the value "Cat"

And what do we do with the rows that have "Cat" in column "B"

Please provide specific details like this:

Thank you for replying! OK, so, as an example, I have the following:

Date of Class need roster for: B2

Sheet 1 Data houses records for all registered students for a fiscal year and the data elements are as follows:

Status. First Name. Last Name. Phone Number. Class Date. Followup Needed Book Level Assigned. Notes
A4. B4 C4 D4 E4. F4 G4 H4

I want to be able copy First Name, Last Name, Phone Number and Book Level Assigned from Sheet 1 into a new Sheet 2 IF the Class Date in Column E matches the Roster Date B2

Is that possible?