A way to do it is to use "Autofilter"

Select the entire sheet, turn on Autofilter, go to the column containing the
data, and set up a filter that looks for the cells that contain "medical".

Then copy and paste the displayed records