Loop through sheets and copy cell if it contains a text

[zach1011]

I am trying to loop through 20-30 sheets within a workbook and copy and paste values into a new sheet if it contains a certain text.

Column B contains the text and I would like to copy the cell in column B and the value in column C. For example, column B has 46 rows and with various names:

Column B Column C
Baseball 5
Football 6
Basketball 2
Baseball 1
Soccer 9
Golf 15
Basketball 17


This is how every sheet is set up and I am trying to copy and paste the values for Baseball and Basketball onto a new sheet at the end of the workbook.

Thanks for the help!