Opening PDF from Local drive based on Cell value

Hello, I have a .xlsm with several sheets. In each sheet, there is a list of values that represent files on my local drive. For example, Sheet 1 has a list of 50 or so numbers (01-123456) that have corresponding pdf files (01-123456-01.pdf) located on a local drive. Sheet 2, Sheet 3, Sheet4, and so on. I'd like to be able to click one of the cells (01-123456) and have it open the corresponding file in my PDF editor. I've looked around and saw someone post the below code that works for just one sheet. I think it would work if I create as many modules as I have Sheets, but this worksheet could have more sheets added at anytime and I'd like to not have to recreate another module each time a sheet is added. I have decent Excel skills, not extensive but decent. And little to no VBA experience. Any help would be much appreciated.

Please Login or Register  to view this content.

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.