Match and autofill new prices & amounts for huge data for each sheet separately

[leap out]

Hello,

I want matching column B for RSH1 sheet with column B for RESS1 sheet , then should brings prices from RSH1 sheet in column G to RESS1 sheet in column G & match column B for RSH2 sheet with column B for REMS2 sheet , then should brings prices from RSH1 sheet in column G to REMS2 sheet in column G

as to column H for RESS1 & REMS2 then should be=column F * column G
every time change data in RSH1& RSH2 sheets should update in RESS1 & REMS2 sheets
here is simple sample for my project

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-1	10W40 208L	Q8	EU	8.00	22.00	176.00
3	2	AA-2	10W40 208L	ENI	IT	3.00	25.00	75.00
4	3	AA-3	5W30 4x4L	Q8	EU	2.00	28.00	56.00
5	4	AA-4	10W40 12x1L	Q8	EU	4.00	31.00	124.00
6	5	AA-5	10W40 4x4L	CAS	SU	2.00	34.00	68.00
7	6	AA-6	5W40 4x4L	Q8	EU	5.00	37.00	185.00
8	7	AA-7	5W40 4x4L	CAS	SU	10.00	40.00	400.00
9	8	AA-8	20W50 4x4L	Q8	EU	15.00	43.00	645.00
10	9	AA-9	10W40 208L	Q9	EU	20.00	46.00	920.00
11	10	AA-10	10W40 208L	ENI	IT	25.00	49.00	1,225.00
12	11	AA-11	5W30 4x4L	Q8	EU	30.00	52.00	1,560.00
13	12	AA-12	10W40 12x1L	Q8	EU	35.00	55.00	1,925.00
14	13	AA-13	10W40 4x4L	CAS	SU	40.00	58.00	2,320.00
15	14	AA-14	5W40 4x4L	Q9	EU	45.00	61.00	2,745.00
16	15	AA-15	5W40 4x4L	CAS	SU	50.00	64.00	3,200.00
17	16	AA-16	20W50 4x4L	Q9	EU	55.00	67.00	3,685.00
18	17	AA-17	10W40 208L	Q10	EU	60.00	70.00	4,200.00
19	18	AA-18	10W40 208L	ENI	IT	65.00	73.00	4,745.00
20	19	AA-19	5W30 4x4L	Q8	EU	70.00	76.00	5,320.00
21	20	AA-20	10W40 12x1L	Q8	EU	75.00	79.00	5,925.00
RSH1

Cell Formulas
Range	Formula
H2:H21	H2	=F2*G2

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-8	20W50 4x4L	Q8	EU	5.00	50.00	250.00
3	2	AA-9	10W40 208L	Q9	EU	5.00	55.00	275.00
4	3	AA-10	10W40 208L	ENI	IT	5.00	51.00	255.00
5	4	AA-11	5W30 4x4L	Q8	EU	4.00	55.00	220.00
6	5	AA-12	10W40 12x1L	Q8	EU	5.00	60.00	300.00
7	6	AA-13	10W40 4x4L	CAS	SU	12.00	66.00	792.00
8	7	AA-14	5W40 4x4L	Q9	EU	10.00	70.00	700.00
9	8	AA-15	5W40 4x4L	CAS	SU	12.00	60.00	720.00
RSH2

Cell Formulas
Range	Formula
H2:H9	H2	=F2*G2

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-13	10W40 4x4L	CAS	SU	5.00
3	2	AA-14	5W40 4x4L	Q9	EU	2.00
4	3	AA-15	5W40 4x4L	CAS	SU	4.00
5	4	AA-16	20W50 4x4L	Q9	EU	3.00
6	5	AA-6	5W40 4x4L	Q8	EU	5.00
7	6	AA-7	5W40 4x4L	CAS	SU	10.00
8	7	AA-8	20W50 4x4L	Q8	EU	15.00
RESS1

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-11	5W30 4x4L	Q8	EU	4.00
3	2	AA-12	10W40 12x1L	Q8	EU	5.00
4	3	AA-13	10W40 4x4L	CAS	SU	12.00
5	4	AA-14	5W40 4x4L	Q9	EU	10.00
6	5	AA-8	20W50 4x4L	Q8	EU	5.00
7	6	AA-9	10W40 208L	Q9	EU	5.00
REMS2

expected result

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-13	10W40 4x4L	CAS	SU	5.00	58.00	290.00
3	2	AA-14	5W40 4x4L	Q9	EU	2.00	61.00	122.00
4	3	AA-15	5W40 4x4L	CAS	SU	4.00	64.00	256.00
5	4	AA-16	20W50 4x4L	Q9	EU	3.00	67.00	201.00
6	5	AA-6	5W40 4x4L	Q8	EU	5.00	37.00	185.00
7	6	AA-7	5W40 4x4L	CAS	SU	10.00	40.00	400.00
8	7	AA-8	20W50 4x4L	Q8	EU	15.00	43.00	645.00
RESS1

sum1.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	AA-11	5W30 4x4L	Q8	EU	4.00	55.00	220.00
3	2	AA-12	10W40 12x1L	Q8	EU	5.00	60.00	300.00
4	3	AA-13	10W40 4x4L	CAS	SU	12.00	66.00	792.00
5	4	AA-14	5W40 4x4L	Q9	EU	10.00	70.00	700.00
6	5	AA-8	20W50 4x4L	Q8	EU	5.00	50.00	250.00
7	6	AA-9	10W40 208L	Q9	EU	5.00	55.00	275.00
REMS2

thanks in advance