Search for files in directory and subdirectories using wildcard

Hi,
I need to look for all files that contain a text string "tip" in their names. Once I find those files, I would open them and copy a worksheet "Input" in to my workbook.
These files are located at different levels within a Directory / Sub directory structure.
The root directory is W:\Projects\.
Then under that there are various Project Folders and Sub Folders. The Files with "tip" string could be under any of those subdirectories.

Can some one point in the right direction or maybe there is a routine available for this type of search?
This search would be similar to the one that Windows Explorer has that will list all paths for these files.

Thanks in advance for any help or guidance on this.

modytrane.