VBA to Search for files in a Folder and Opens it

[vnzerem]

I have a spreadsheet and the content has different file names that are arranged in a single Column. For example, in Column A, I have the following file names.

A1: Math2.xlsx
A2: Math1.xlsx
A3: Eng1.xlsx

These files are located in the directory C:/Projects/Sample

But the problem is this: Under the Sample folder, I have so many other folders created there (about 10). Hence I don’t know exactly the location of the files listed above in the Sub Folders.

I need an excel macro that can search for the files listed from A1 to A (whatever) and show me where it is exactly located under the Sample Sub-Folders and open it when I click on it. For example in A1 if I click on Math2.xlsx, it will show me the sub folder (Under Sample Folder) where it is located and opens it up.
Is this possible?

Thanks in advance so much for your time.