Hello, I am trying to create a formula that references another spreadsheet. I
am able to do this at a manual level but what I am really looking to do is to
list a number of file names on one sheet and have the formula pull the file
names from that sheet and insert it into the reference formula. Here is an
example of what I have tried that has not worked:

=IF(ISERROR('[ Sheet1!E3 ]Approval Summary'!$C$13),0,'[ Sheet1!E3
]Approval Summary'!$C$13) + IF(ISERROR('[ Sheet1!E4 ]Approval
Summary'!$C$13),0,'[ Sheet1!E4 ]Approval Summary'!$C$13)

Where Sheet1!E3 would hold something like "abc.xls" If anyone can help with
this I would greatly appreciate it.

Thank You,
Steve