match sheet name with item into list and add the missed

[Abdo]

Hello
in CREATE LIST sheet I want matching items in column C with sheets names and brings the items for DESCRIBE column & value for TOTAL column and put missed item under item is matched with sheet name and summing .
if there is duplicates item in the sheet ,then should merge and summing amount as in PUR EXPENSES sheet .
example

Re-calculation (1).xlsm
	A	B	C
1	ITEM	AMOUNT	ACCOUNT NAME
2	1	1,369,450.00	PUR
3	2	561,000.00	PUR EXPENSES
4	3	398.281	PUR RETURN
5	4	1520	PUR DISCOUNT
6	5	1,928,531.72	NET PUR
7	6	1,365,170.00	BEGINNING STOCK
8	7	3,293,701.72	COST OF THE GOODS TO BE SOLD
9	8	1,054,850	ENDING STOCK
10	9	2,238,851.72	COST OF THE GOODS SOLD
11	10	7,068,126.20	SALES
12	11	0.00	SALES EXPENSES
13	12	1,957.00	SAL RETURN
14	13	45,700.00	SAL DISCOUNT
15	14	7,020,469.20	NET SALES
16	15	4,781,617.48	NET REVENUE
17	16	400,000.00	GENERAL EXPENSES
18	17	4,381,617.48	NET INCOME
CREATE LIST

Re-calculation (1).xlsm
	A	B	C	D	E
1	DATE	DESCRIBE	QTY	PRICE	TOTAL
2	18/02/2022	Goods transport rental	10.00	1,200.00	12,000.00
3	19/02/2022	Hire of unloading workers	20.00	500.00	10,000.00
4	20/02/2022	Goods transport rental	20.00	1,400.00	28,000.00
5	21/02/2022	Hire of unloading workers	200.00	600.00	120,000.00
6	22/02/2022	Goods transport rental	120.00	1,800.00	216,000.00
7	23/02/2022	Hire of unloading workers	250.00	700.00	175,000.00
8
9
10
PUR EXPENSES

Re-calculation (1).xlsm
	A	B	C
1	DATE	DESCRIBE	TOTAL
2	01/02/2022	SALARY	100000
3	02/02/2022	RENTALS	300000
GENERAL EXPENSES

result

should put missed items under PUR EXPENSES & GENERAL EXPENSES as highlighted by green color

Re-calculation (1).xlsm
	A	B	C
1	ITEM	AMOUNT	ACCOUNT NAME
2	1	1,369,450.00	PUR
3	2	561,000.00	PUR EXPENSES
4	3	256,000.00	Goods transport rental
5	4	305,000.00	Hire of unloading workers
6	5	398.281	PUR RETURN
7	6	1520	PUR DISCOUNT
8	7	1,928,531.72	NET PUR
9	8	1,365,170.00	BEGINNING STOCK
10	9	3,293,701.72	COST OF THE GOODS TO BE SOLD
11	10	1,054,850	ENDING STOCK
12	11	2,238,851.72	COST OF THE GOODS SOLD
13	12	7,068,126.20	SALES
14	13	0.00	SALES EXPENSES
15	14	1,957.00	SAL RETURN
16	15	45,700.00	SAL DISCOUNT
17	16	7,020,469.20	NET SALES
18	17	4,781,617.48	NET REVENUE
19	18	400,000.00	GENERAL EXPENSES
20	19	100,000.00	SALARY
21	20	300,000.00	RENTALS
22	21	4,381,617.48	NET INCOME
CREATE LIST

notice: I will add new sheets with same structure so should brings any missed items under item in CREAT LIST sheet with same way if the sheet name is existed in the list for CREAT LIST sheet to match with sheets names .
thanks

 

[Abdo]

is there any help ,guys?

 

[Abdo]

posted here
add missed item under item into list based on matching with sheet name