If the data in sheet 1 matches the data in sheet 2, then copy the data of a different cell in sheet 2 to sheet 1

[FariAb]

Hi everyone! I have 2 sheets, the first one looks like this:

Dates	Date 1	Date 2	Date 3
Demand	1	2	3

And the second one looks like this:

Demand​	Random info​	Random info​	Cost​
1	x	x	$15
2	x	x	$26
3	x	x	$37

I'd like to have a macro that copies the costs of sheet 2 to sheet 1 if the demand matches. I am aware that this could be done via an Excel formula, but there is an array of "sheet 2" sheets, it isn't the same one every time the macro will run. I have the macro to change the sheets based on the demand you want to get, only the copying and pasting part isn't working.

Does anyone know how this could be solved?

Thank you in advance.