getting data from cells in wrksheet & importing in existing works

[Guest]

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?

 

[Guest]

hi,
=('C:\WOMonitor\FY03\[Jan.xls]MPX'!$A$4)
here is one i use to create a summery sheet from 12
monthly files.
you can use =sum and =count too.
=SUM(COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$Z$4:$Z$500)-
COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$AC$4:$AC$500))