Copy, eliminate, consolidate

[Ricardo9211]

Hello all,
I have a project and to be honest with you not even sure how i can do this so thought somebody may have an idea for me. this is what i have right now

Bookcisco.xls

now what i need to do is this. i need to macro this information out to another sheet and do this if C= yesterdays date and B= "Login/Not Entered" then copy that row and place in sheet2. then i need if c=yesterdays date and B="End_OF_Shift" then copy row and place under the "Login/Not entered" Row and this has to keep happening until the end of data or blank row.
can this be done with a macro or should it be a formula in the cells on sheet 2. the problem with the formula is it will not consolidate all the data

need some serious help here

[JBeaucaire]

You can use the AUTOFILTER to do this manually, macro not required. The Data > Filter > Autofilter allows you to filter the data in place, hiding the rows that don't match what you want.

Some people find that once they start using the AutoFilter they no longer need to actually copy stuff off to another sheet, but you can. If you activate the filter, filter column C by yesterday's date, then filter column B by the string of interest, you can then copy everything still visible to another sheet and only the visible rows will get copied.