find & copy value in different sheets

aysrun

i have two sheets where i need to take in values in sheet2 to display in sheet1. instead of copy pasting, i want to create a macro since its easier.

Sheet1:

A B C
1 KPI Card Paper
2 Income
3 Losses


Sheet2:

A B C
1 KPI Card Paper
2 Income 12 13
3 Losses 9 5

i need to display the numbers in Sheet1 but based on the following:

if i click on the third cell in column B to get the value for income, the macro is supposed to read the value in col B row 1, find a match in sheet2's range
A1:C1, go back to sheet1 and read value in A3, find a match in sheet2's range A1:A3. if it satisfies both conditions, the value displayed in sheet1 will be retrieved from B2 in sheet2.

any idea?