Specific url/folder called up in Macro. How to make that url dynamic?

I have a macro that creates a link of all the pictures I have in a folder. 100 pictures in Folder Jan 2013 will create 100 hyperlinks in excel.

The problem I face now is that the template that I currently use is used all year. So if I have a random amount of photos in Feb 2013, Mar 2013, Apr 2013, etc. I should have that exact same amount of photos from those folders.

I don't have to want to go every single time to the macro and change the folder/url location. Is there a way I can have the macro say to get the files from cell Z1

where Z1 is a dynamic hyperlink I have created?
Part of Z1 recalls other cells. A1 says Month:, and B1 = Feb 2013

If I update B1 every month to the new month, then the hyperlink in Z1 will automatically update. However, how can I use that dynamic hyperlink reference in the macro instead of having to always literally spell out the file location?

Does a Macro allow to recall a specific folder by referring to the Spreadsheet cell instead of the file address?

This is the macro that I have

Please Login or Register  to view this content.

Because every month the URL address will be different, I don't want to have to go every month and change:

1) The month section of the URL: 05 May\
2) The name of the inspector Frank Butler\

Rather than put in the macro the full URL path, how can I have it say instead

Set fol = fs.getfolder("\\ABCDEFG.com\workgroupABC\TDBU26\E&TS DR\Working\Quality\Inspections\M&I_Inspections\Photos_ODI\05 May\David Butler\")

to

Set fol = fs.getfolder("A34")

Where A34 in the cell of Sheet1 (or whichever sheet) gives the updated URL.

Is what I'm asking for possible in excel vba?

Does anyone know?

Can anyone at least point me to the right path?

I have tried google searching but I can't seem to find anywhere what I am looking for.

Once I set the file path in the macro, can't I change it so that rather than putting the path, I can put the cell address (example: B31) and that way I can keep it dynamic?

I give up.

instead of:

Please Login or Register  to view this content.

Use:

Please Login or Register  to view this content.

This will set the folder to the URL stored in cell A34.