The project I am working on has 1 workbook that has outside users entering data. The data filled workbook is then "Saved As" with a new file name leaving the original template to be used again and again.

However, the data captured needs to be input into a letter. I have set up hyperlinks to insert the data into a word document as well as a letter set up in Excel. However, once the letters are reviewed, if any changes need to be made, the hyperlinks don't work if I or anyone else) goes into the newly named file to make the edits as the links are associated to the original template name.

How do I create a hyperlink that will accept the data from the original template or the newly named file?

I was thinking about creating a mail merge word document to be populated by an excel database. The excel database would be populated by data from the hyperlink in the respective individual workbooks.

Is it possible to create a hyperlink using a wildcard of somesort to accept the data from excel files within a folder?

Many thanks.