populate Total amount from different cells across workbooks based on sheets names

[KalilMe]

Hello
I need populate values in column B based on sheets names in column A for MASTER file , should match with the sheets names across files . should search for
the last cell contains value is existed in last column and in last row .
all of the files are existed in the same folder "C:\Users\KILL\Desktop\REPORT"
first file

KIL.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ITEM	DATE	NAME	INVOICE	GOODS	TYPE	PR	QTY	UNIT	TOTAL
2	1	25/05/2023	CR-1000	FRVG-1000	ATR	AM1	GR	55	22	1210
3	2	25/05/2023	CR-1000	FRVG-1000	ATR	AM2	PO	14	33	462
4	3	25/05/2023	CR-1000	FRVG-1000	ATR	AM1	SO	10	44	440
5	TOTAL	25/05/2023	CR-1000	FRVG-1000						2112
6	1	25/05/2023	CR-1001	FRVG-1001	ATR	AM1	GR	10	22	220
7	2	25/05/2023	CR-1001	FRVG-1001	ATR	AM2	PO	10	33	330
8	TOTAL	25/05/2023	CR-1001	FRVG-1001						550
SALES

Cell Formulas
Range	Formula
J5	J5	=SUM(J2:J4)
J8	J8	=SUM(J6:J7)

KIL.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ITEM	DATE	NAME	INVOICE	GOODS	TYPE	PR	QTY	UNIT	TOTAL
2	1	25/05/2023	CR-1000	STVG-1000	ATR	AM1	MTR	5.00	25.00	125.00
3	2	25/05/2023	CR-1000	STVG-1000	ATR	AM2	PO	4.00	35.00	140.00
4	3	25/05/2023	CR-1000	STVG-1000	ATR	AM1	SO	2.00	45.00	90.00
5	TOTAL	25/05/2023	CR-1000	STVG-1000						355.00
6	1	25/05/2023	CR-1001	STVG-1001	ATR	AM1	GR	2.00	23.00	46.00
7	2	25/05/2023	CR-1001	STVG-1001	ATR	AM2	PO	2.00	35.00	70.00
8	TOTAL	25/05/2023	CR-1001	STVG-1001						116.00
PURCHASE

Cell Formulas
Range	Formula
J5	J5	=SUM(J2:J4)
J8	J8	=SUM(J6:J7)

KIL.xlsm
	A	B	C	D	E	F	G
1	ITEM	GOODS	TYPE	PR	QTY	UNIT	TOTAL
2	1	ATR	AM1	GR	55	22	1,210.00
3	2	ATR	AM2	PO	14	33	462.00
4	3	ATR	AM3	SO	10	44	440.00
5	TOTAL						2,112.00
STOCK

Cell Formulas
Range	Formula
G5	G5	=SUM(G2:G4)

second file

CM.xlsm
	A	B	C	D	E
1	DATE	INFORMATION	DEBIT	CREDIT	BALANCE
2	25/05/2023	BUYING GOODS INVOICE NUMBER FRVG-1001		545	-545
3	25/05/2023	SALES GOODS INVOICE NUMBER STVG-1001	116		-429
4	25/05/2023	SALES GOODS INVOICE NUMBER STVG-1002	46		-383
5	TOTAL		162	545	-383
CR

Cell Formulas
Range	Formula
E5	E5	=C5-D5

CM.xlsm
	A	B	C	D	E
1	DATE	INFORMATION	DEBIT	CREDIT	BALANCE
2	25/05/2023	BUYING GOODS INVOICE NUMBER FRVG-1000		2112	-2112
3	25/05/2023	BUYING GOODS INVOICE NUMBER FRVG-1002		1200	-3312
4	25/05/2023	SALES GOODS INVOICE NUMBER STVG-1000	365		-2947
5	TOTAL		365	3312	-2947
TR

Cell Formulas
Range	Formula
E5	E5	=C5-D5

before

MASTER.xlsm
	A	B
1	SHEETS NAMES	TOTAL
2	SALES
3	PURCHASE
4	STOCK
5	CR
6	TR
REPORT

should be

MASTER.xlsm
	A	B
1	SHEETS NAMES	TOTAL
2	SALES	550
3	PURCHASE	116
4	STOCK	2112
5	CR	-383
6	TR	-2947
REPORT