VBA to retrieve the file path from ANY drive by inputting whole or part of a filename.

Hi,
I am trying to work on a problem to make the operations simpler at the organization.
I want to enter whole or part of a filename and want to receive the file path for all files that match the substring I enter. The program should search through all the hard drive files (even subfolders) and network files.

For example:

I type in cell A1: "7556"
Output in B1: "7556N0142 folder path F:\Drawings\released drawings\7556N0142"
B2: "7556N0136 folder path F:\Drawings\released drawings\7556N0136"

Any help will be greatly appreciated. I have worked on a lot of programs in excel in the past but this is too complex for me. I belong to mechanical engineering background but I can understand the algorithms and logics easily.

Thanks a lot for the help and suggestions. I will try it out. Also, a bit off topic but except excel VBA what other programming/tools can I use to solve this problem. I can learn the programming language required to do this.

Few that comes to mind are...
Windows PowerShell
Windows Command Line (batch file)
GREP

I prefer Command line (batch file) to output result into text file.

You can then read that file into Excel.