I need to be able to display a file search in a specific folder(same
folder every time)and allow the user to select a worksheet from that
list to apply some more code that will come later. Right now, I just
need to figure out how to make the file search work.

Sorry for the similar post earlier, but I really need help and I
haven't been able to make any of the solutions I found here work.

Thanks to all.