Populate different prices across sheets based on option button &combobox

[Alaa mg]

Hi
I want after select for each combobox separately should brings the price from multiple sheets(BTT,MTT,STT) as to QTY should just bring from sheet TOTAL based on match column B across sheets. so the idea when select item from combobox and select optionbutton cost then should search across sheets(BTT,MTT,STT) the column COST if the item just is existed and repeated in the same sheet then should populate the price for each textbox based on select for each combobox based on last price for last duplicated item but if the items is existed for next sheet whether the item is repeated or not then should populate based on last sheet the item is existed and ignore that sheet precede it . for instance the cost in sheets BTT,MTT for item ATR-100 =11.5,13,12 then should populate 12 another example if there is just in the same sheet lik ATR-101 then the cost will be last price for duplicate item , 10.5,9 then should populate 9
the same thing about opionbutton sales like the optionbutton cost
last thing as I mentioned from the beginning populate QTY IN MULTIPLE TEXTBOXES after select from multiple comboboxes should be based on sheet TOTAL
here some examples
when select optionbutton & combobox should populate values in textboxes

data in sheets

MODIFYIN.xlsm
	A	B	C	D	E
1	DATE	CODE	QTY	SALES	COST
2	01/01/2022	ATR-100	12	12.3	11.5
3	02/01/2022	ATR-101	11	13.3	10.5
4	03/01/2022	ATR-102	11	14.3	10
5	01/01/2022	ATR-100	12	11	13
6	02/01/2022	ATR-101	11	12	9
7	04/01/2022	ATR-103	11	13.3	15
8	05/01/2022	ATR-104	11	15.3	11
9	06/01/2022	ATR-109	11	15.3	11
10	03/02/2022	ATR-110	1	10	12
BTT

MODIFYIN.xlsm
	A	B	C	D
1	DATE	CODE	QTY	COST
2	03/02/2022	ATR-102	3	11
3	04/02/2022	ATR-103	4	11
4	05/02/2022	ATR-104	5	12
5	01/02/2022	ATR-100	1	12
6	01/02/2022	ATR-102	1	15
7	03/02/2022	ATR-108	12	10
8	03/02/2022	ATR-110	3	11
9	04/02/2022	ATR-111	12	12
10	04/02/2022	ATR-1112	12	12
11	05/02/2022	ATR-1113	12	12
12	06/02/2022	ATR-1114	12	12
13	07/02/2022	ATR-1115	12	12
14	08/02/2022	ATR-1116	12	12
15	09/02/2022	ATR-1117	12	12
16	10/02/2022	ATR-1118	12	12
17	11/02/2022	ATR-1119	12	12
18	12/02/2022	ATR-1120	12	12
19	13/02/2022	ATR-1121	12	12
20	14/02/2022	ATR-1122	12	12
MTT

MODIFYIN.xlsm
	A	B	C	D
1	DATE	CODE	QTY	SALES
2	01/03/2022	ATR-100	1	14
3	04/03/2022	ATR-103	4	17
4	05/03/2022	ATR-104	5	18
5	01/03/2022	ATR-100	1	15
6	02/03/2022	ATR-101	2	16
7	03/03/2022	ATR-102	3	16
8	03/03/2022	ATR-101	2	17
9	04/03/2022	ATR-103	3	17
10	05/03/2022	ATR-107	3	17
11	04/02/2022	ATR-111	1	13
12	03/02/2022	ATR-110	3	14
13	03/02/2022	ATR-1110	3	14
14	04/02/2022	ATR-1111	3	14
15	05/02/2022	ATR-1112	3	14
16	06/02/2022	ATR-1113	3	14
17	07/02/2022	ATR-1114	3	14
18	08/02/2022	ATR-1115	3	14
19	09/02/2022	ATR-1116	3	14
STT

MODIFYIN.xlsm
	A	B	C
1	ITEM	CODE	QTY
2	1	ATR-100	200
3	2	ATR-101	300
4	3	ATR-102	400
5	4	ATR-103	500
6	5	ATR-104	600
7	6	ATR-105	601
8	7	ATR-106	602
9	8	ATR-107	603
10	9	ATR-108	604
11	10	ATR-109	605
12	11	ATR-110	606
13	12	ATR-111	607
14	13	ATR-112	608
15	14	ATR-113	609
16	15	ATR-114	610
17	16	ATR-115	611
TOTAL

thanks

 

[Alaa mg]

is there any help?