Need A Macro That Automaticly searches files in desktop to find .dwg file to hyperlink too

Hello, I am trying to figure out a macro that can take a set document that I already have in excel with 20,000 specific numbers that will correspond to .dwg drawings with the same number for the name, that are in my desktop and run it so that it goes through each number in each row in the specific cell column ( excel column B).


If that's not clear, I'm simply trying to search my computer and have it notice that ((in terms of what I want the computer to think) "Hey in this row that I'm supposed to go down and check, there is a .dwg file name that corresponds with this name in this row of the column, so ill just ask the user if this is the correct file and then I'll automatically link it."

The only problem with that, (I should have mentioned this in the post) is that my files are located in different folders, there's a folder for a unit, and a type, and so forth. It has to go through many different folders to find the dwg that I would need. And every number has a different corresponding dwg file, so if I copied and that formula all the way down would it keep the cell the same, and simply hyperlink it, leaving the number completely the same?

Thank you for your help.

Also considering that there are over 20,000 dwg files to search for, I am not quite sure what path to use on each piece of equipment since they are all located in different folders