Updating workbook values from another file based on specific criteria

[c_omran]

Hello, I have one file that contains the forecast analysis for the coming quarter for all functions, I want a macro that will update with Master Budget file based on the budgeted item and the function, below is my example , I want a macro to update Workbook 2 values from Workbook 1 based on the budget item name and the function, so in the below example, communication cost for sales in Workbook 2 will be 150000, and so on
Thanks

Workbook 1,Tab X
[TABLE="width: 500"]
<tbody>[TR]
[TD]Budget Item[/TD]
[TD]Function[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Communication Cost[/TD]
[TD]Sales[/TD]
[TD]150000[/TD]
[/TR]
</tbody>[/TABLE]

Workbook 2, Tab x
[TABLE="width: 500"]
<tbody>[TR]
[TD]Budget Item[/TD]
[TD]Function[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Communication Cost[/TD]
[TD]Sales[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Communication Cost[/TD]
[TD]HR[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]