Open PDF files when click specific cell within folers and subfolers in directory

[Mussala]

Hi
I have INVOICE NUMBERS in column D for sheets(SALE , BUY,RETURNS) .
I have all of files PDF in "C:\Users\MSS\Desktop\INVOICE\" and contains many folders and subfolders .
so what I want when select any cell in column D and click then should search in "C:\Users\MSS\Desktop\INVOICE\" within folders and subfolders and open it.
so should search for all PDF "C:\Users\MSS\Desktop\INVOICE\ regardess where is existed in folder or subfolde.the most important is matched with column D. if it's not existed then should pops message" the file is not existed "
thanks