Hello everyone! Learning to use VBA and still a novice!

I have a job list where each row is information about the job. Column B is the job number always in the same format of letters and numbers (example: 2015-AAAA-001). The file related to it will always be a .pdf and will always start with job number (example 2015-AAAA-001 - Document1.pdf). I am trying to create a macro that allows the user to either us an Application.Input off of a command button and then click the job#, or if it would automatically hyperlink to the file. I am not sure which would be faster/more realistic to code. The master directory could be C:\Master and have subfolders with subfolders that would have to be searched through.

I have tried to code this different ways and have failed every time! If anyone can help it would be greatly appreciated!

Thank you!