How to efficiently link large row data model with multiple columnar excel sheet?

[Alones]

My power pivot model is as below
ledger acc #	ledger name	month	cost center	expense group	budget	Actual
10001	depreciation	16-Apr	admin	depreciation & amortization	23,455	1960
10002	salaries	16-Apr	admin	employee cost	5,038,854
10001	depreciation	16-Apr	hr	depreciation & amortization	8,573
10002	salaries	16-Apr	hr	employee cost	93,848
10001	depreciation	16-May	admin	depreciation & amortization	23,455
10002	salaries	16-May	admin	employee cost	5,038,854
10001	depreciation	16-May	hr	depreciation & amortization	8,573
10002	salaries	16-May	hr	employee cost	93,848
and so on for 12 months for each cost center
please note that there are more than 20 cost centers and model contains approximately 7000 rows
now I need to compare budget with actual , the report / TB I am getting from system is structured like below
Excel file
ledger acc #	ledger name	admin	hr	total	month
10001	depreciation	1,960	700	2,660	16-Apr	added manually
10002	salaries	42,000	7,800	49,800	16-Apr	added manually
Query
What is the most efficient way to get this data in my existing power pivot model?

<tbody>
</tbody>

I have achieved this by =IF(D4=C20,SUMIFS(C21:C22,A21:A22,A4,B21:B22,B4,F21:F22,C4),0), the result is 1960 as shown above <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Matt Allington]

Have a look at this. You effectively have 2 data tables which I cover in this article. Multiple Data Tables in Power Pivot - Excelerator BI

 

[Alones]

Have a look at this. You effectively have 2 data tables which I cover in this article. Multiple Data Tables in Power Pivot - Excelerator BI

Thanks Matt, its good insight, appreciate your reply and effort.

Regards.