Compile Error: Ambiguous Name Detected: Worksheet_Change

Hello! I am trying to use a script that allows me to select multiple options from a drop down box but am now having issues with this error popping up when I attempt to make a selection. I'm confused as to what I did wrong here. I did change the name to Worksheet1_Change just so I could save it and attach it here. Any help is greatly appreciated!!

You have the same "Worksheet_Change" declaration twice.
Combine the two into one.

I've tried to do this but I'm not sure how to do so accurately. Everything I've tried so far makes it so that it doesn't actually filter the list anymore. It just allows me to select multiple options. Would you be able to show me how to do this correctly? And thank you for your reply!

Explain in detail what you want to achieve.
It is helpful if you can attach a workbook with a before and after manually prepared sheets.

I am trying to create a drop down menu that will allow me to make multiple selections plus show any results that contain the selected option in any way. This is supposed to be so that I can easily see the tests that I need to search for, filtering out all of the tests that I'm not focusing on at that time. So the drop down menu is in D1. I want to be able to select "Urine" and it show me all the results that contain "Urine" whether it's by itself or with a list of other tests ran as well. I also want to be able to select "Urine", "HIV", and "Pap Smear" and have it return all valid responses to me. I also want it to be able to recognize any version of (for example) "Pap Smear", whether it was spelled with capitalization or not, etc.

I've attached a "before" workbook but I don't have any sort of "after" besides what I attached in the original post. I'm not sure if this is what you are asking for though. Thank you for your help!!

@davesexcel Sorry! I did not see your previous post! I fixed it as you indicated- thank you! :D