Taking path name from another excel sheet

Hi
I need help in these. I have attached an excel file which enables to import sheets and other stuff(Thanks to tigeravatar) What I would like to do now is assume that there is a new sheet called the path name with the path in the range (A1). So whatever is in the range A1 would be the path name, thus the person would not need to change it through the coding. Please help! Thanks