Here is the application...I have a master worksheet that needs to pull
information from specific sells in several different files (excel worksheets)
in defferent directories. The filenames will change but the fields will be
the same. I have been using manual links and cut&paste to place the
information in the master worksheet. Is there a way to define a directory
path and filename is some cell within the master worksheet to use as a
reference for the linked cell to look so that it will automatically retrieve
the information without manual intervention?