I suppose I forgot to mention that there are several local folders that contain the pdf files. 01-123456 is in folder C, 07-891234 is in folder D, and so on. The folder structure is "C:\Users\Documents\Main\Category (A and B are subfolders)\Subject (C thru H+ are where the PDFs I'm trying to call are stored)". You are right that the above does work, but only to the one location. I need to be able to call from the Subject folders based on what each sheet corresponds to. And more Subject folders may be added. I apologize that I forgot to mention this earlier. Thank you for your response.