Need help! - Search Macro to retrieve a file from a subdirectory

[Caveman1964]

Hi!
I would like a search macro to retrieve a file from a subdirectory and the file will have a lot number with report on end and be a .xlsm. and then it retrieves it.
Example;
Click button for msgbox to ask what lot number
user enters it
then it searches through "L:\Job Packets"Product""Lot numbers""Lot number+report.xlsm"
real example
L:\Job Packets\WheelBarrel\123456\123456report.xlsm
User to enter 123456 and it gets the 123456report.xlsm

Thanks for any help on this.
if the msgbox is too much then he/she could just enter in a cell but prefer the msgbox from clicking macro. Either way will work.
Thanks

 

[Caveman1964]

So what about just a macro that retrieves a file?
I am working on this still don't have it working. If someone could get me started, I could possible figure it out.
Thanks!