Sumproduct with closed workbook

[spycein]

Hi Everyone,

I have two workbook, one is data sheet and another one is report sheet.
I am trying to pull out the values from my data sheet workbook to my report sheet wokbook.

I tried both sumifs and sumproduct, but both formula work once the source file gets opened.

I need a formula which can update the value without opening the source file i.e. datasheet workbook.

Datasheet Workbook ( Path :D:\SHIB\BUDGET 2017\Budget Report 2017 Presentation\Datasheet Workbook.xlsm)

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Quater[/TD]
[TD]Budget Head[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]Q1[/TD]
[TD]Professional Charges[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]Q2[/TD]
[TD]Professional Charges[/TD]
[TD]3000[/TD]
[/TR]
</tbody>[/TABLE]






[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Budget Head[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]Professional Charges[/TD]
[TD]=Formula[/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]Professional Charges[/TD]
[TD]=Formula[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much.