Excel - filtering values and copying data to new sheet

I'm looking to filter and move data from a main excel spreadsheet (sheet 1) into a new sheet (sheet 2) but all the advice I've found so far relates to filtering just one column of data and I want to move two. I also need to filter by a wildcard.

I've attached an image of my sheet 1, and what I'd ideally want to create in sheet 2.

Column A is date; column B is animal type; column C is weight.

I need to filter by a wildcard to find all the 'horses' in column B and then move the date, the animal type and the weight to spreadsheet 2.

I've managed to do the first part using

=IF(COUNTIF(Sheet1!B2,"horse"),Sheet1!B2,"")

but I'm stuck on the 2nd part of removing all the blank rows.

Thanks so much for any assistance.

Animal weights