Hi, I'm working with a job list (generated out of a different program) and
data in associated closed workbooks. For example, the job list has names like
HD-100311-TA031110, SHT-100312, 032110Mag and I can generate a list of these
jobs along with other information I need. For every job there's an associated
workbook and, without opening the workbook I want to pull, for example,
'[\\de-mt1\clients\QC Reports\Proofs Adjusted\HD-100311-TA031110 proof
adjusted.xls]'Upload'!A$2 where the only information that will change is the
job name. I'm novice enough not to know how to do this even if the workbook
is open using the INDIRECT function.

My current workbook has two tabs, one where I paste the job list and other
details straight from my export. The second tab then references the first
tab, then I want to pull data from the closed workbooks. (I have to make sure
things like the listing counts match, for example.) The bulk of what I need
to do is get data from these closed workbooks. The number of jobs is very
dynamic and will probably be at least 50 most of the time.

In reading postings I found references to Harlan Grove's PULL function a
supposedly faster one from Wilson So called IndirectEx but both are way over
my head. Figuring this out will save tons of manual effort every week so it's
worth me trying to figure it out. Can you help?
--
Jen