I am trying to create a summary worksheet based on other worksheet
contents (that will be created in the future). I am looking to
automate this and am having difficulty auto referencing hyperlinks.
For example, I have a cell A1 with the folder path and cells a2...
have sequential numbers. I then create hyperlinks in b2... using these
references to make up the file name. What I then need to do is insert
information from the other worksheets into in cells c2..f2 etc. I want
to use cell references a1 and a2.. to create the hyperlink so that it
is easily updated if the filename or path change but cannot seem to do
this. I have tried various methods but am only currently stuck with
entering the entire filename and path. I am new to this so want to
avoid VB if possible.

Sandy L