Dragging Down Reference to Another Workbook Cell

[jackee96]

Good afternoon,

I have been trying and researching how to do the following for months now... I even came on here before with no success. Please let me know if you are available to help!

I have a master workbook that I reference data from hundreds of excels on.

I am trying to reference the cell "BU7" that has the workbook name (NT-13-001) in it, to reference sheet name "Purchase Order" at cell "H13".
Next line I would like to reference the cell "BU8" that has the workbook name (NT-13-002) in it, to reference sheet name "Purchase Order" at cell "H13".
.
.
.


The computer path is K:\FRG TOOL REQ\2013\NT Forms\NT-13-001

This is the formula I have tried... I have also attempted the INDIRECT function & Hyperlink GO TO.

=IFERROR('K:\FRG TOOL REQ\2013\NT Forms\["&DU7&".xlsx]Purchase Order'!$H$13,"")

This would save me an exorbitant amount of time if someone could help me, I would truly appreciate it.

Sincerely,
Jackie

[Jacc]

Remove the $ signs.
http://www.cpearson.com/excel/relative.aspx