Its having a problem with the end of it.

"sum(indirect('"C:\Doc....\["&D3&".xls]Sheet1'!C5+C6"')"

That C6"' keeps being highlight and said its wrong. if i take it away it just says #ref!

so i can't tell if that works or not.