Excel 2007
Win XP Professional


Current Setup
A: Date (m/dd/yyyy)
C: Amount (needs to be pulled from the appropriate file based on the date)
F: Path (\\server\folder1\folder2\[filename part 1
G: Variable (date in mmddyy format)
H: Part III (remainder of filename]Sheet!)
I: Column ($AP) - this will be a variable also.
J: Cell ($6)

So, if I concatenate in Column K (=F5&G5&H5&I5&J5) I get
\\NTS141\KEGCommon\KE - Jasper\Inventory Projection Detail\[Inventory
Projection - KE Jasper wk092208 rev4 with KETL change.xls]Input Planned
Sales!$AP$6

What I want is the value that is in the referenced cell. I thought I was
going to need to use INDIRECT but I haven't been able to get my head around
it.

If I need to set up in a different manner or if INDIRECT is not the way to
go please advise.

Thank you in advance!