Search entire sheet for text

Hello,

I have a test that I need to run over 100 times where I drop raw data (a pdf converted to excel) into the data sheet tab on the attached and perform a search based on a list on the List tab to see if it finds a match so that I can flag where matches are missing. It doesn't need to be a loop for 100 times. There would be a separate file for each test. I tried =COUNTIF(Sheet1!$1:$1048576,"*"&'Exhibit 7 - Lease in Place'!D13&"*") but it doesn't seem to be working for many in the list. Any ideas how I can do this? The raw data comes out with many different variations of the converted data and I don't have time to build a macro to clean up the converted pdf info.