Formula to see if text in cell A1 is present in specific filepath

Hi,

I'm trying to find a formula/macro that will lookup the last and first name as it appears in Cell A1, and tell me in Cell B1 "Yes" or "No" if this name (*Last Name & First Name in any order) appears in any of my .pdf document names of a specific filepath (Ex. C:\Employee\Records).

I also need this formula to work for other preceding names in Column A. Is this possible?

Column A
A1 - Smith, John
A2 - Monroe, Marilyn

Column B
B1 - Returns "Yes" or "No"
B2 - Returns "Yes" or "No"