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)

Year	Quater	Budget Head	Amount
2016	Q1	Professional Charges	2000
2017	Q2	Professional Charges	3000

<tbody>
</tbody>

Year	Budget Head	Amount
2016	Professional Charges	=Formula
2017	Professional Charges	=Formula

<tbody>
</tbody>

Thank you so much.