extraction invoices information from multiple sheets based on DATE TODAY

[KalilMe]

Hi guys
I need match sheet name with column C for sheets(SALES,BUYING,VOUCHER) based on date today
example CR-1001 sheet when match with column C for the same name then should brings DATE,INVOICE,TOATL from the last row(TOTAL) column B,D,J from BUYING sheet and put in columns A,B,D and calculate in column E as I put the formula in CR-1001 sheet , as to SALES sheet should brings DATE,INVOICE,TOATL from the last row(TOTAL) column B,D,J from SALES sheet and put in columns A,B,C and calculate in column E as I put the formula in CR-1001 sheet, as to VOUCHER should match C5,F5 with sheet name then should brings A3,D3,H6 from VOUCHER sheet to CR-1001 in columns A,B,D
in VOUCHER sheet about F5 will be different when copy amount if the word is SALES then will be in column D , if the word is BUYING will be in column C
I want copy theses data based on date today and sum the whole column C,D
last thing every time will add new data in sheets(SALES,BUYING,VOUCHER) and add new sheets names based on matching with column C for the others sheets then should update sheet name contains customer .
notice: the data in sheets sheets(SALES,BUYING,VOUCHER) could contains 5000 rows for each sheet.

MMVO.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ITEM	DATE	NAME	INVOICE	GOODS	TYPE	PR	QTY	UNIT	TOTAL
2	1	19/07/2023	CR-1000	STVG-1000	ATR	AM1	MTR	5	25	125
3	2	19/07/2023	CR-1000	STVG-1000	ATR	AM2	PO	4	35	140
4	3	19/07/2023	CR-1000	STVG-1000	ATR	AM1	SO	2	45	90
5	TOTAL	19/07/2023	CR-1000	STVG-1000						355
6	1	20/07/2023	CR-1001	STVG-1001	ATR	AM1	GR	2	23	46
7	2	20/07/2023	CR-1001	STVG-1001	ATR	AM2	PO	2	35	70
8	TOTAL	20/07/2023	CR-1001	STVG-1001						116
9	1	20/07/2023	CR-1000	STVG-1000	ATR	AM1	MTR	2	25	50
10	2	20/07/2023	CR-1000	STVG-1000	ATR	AM2	PO	2	35	70
11	3	20/07/2023	CR-1000	STVG-1000	ATR	AM1	SO	2	45	90
12	TOTAL	20/07/2023	CR-1000	STVG-1000						210
BUYING

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

MMVO.xlsm
	A	B	C	D	E	F	G	H
2	DATE			VOUCHER NO
3	20/07/2023			VTR-110		INVOICE
4			NAME			SALES
5			CR-1001					TOTAL
6								300
VOUCHER

before

MMVO.xlsm
	A	B	C	D	E
1	DATE	DETAILS	DEBIT	CREDIT	BALANCE
2
3
4
5
6
CR-1001

expected

MMVO.xlsm
	A	B	C	D	E
1	DATE	DETAILS	DEBIT	CREDIT	BALANCE
2	20/07/2023	STVG-1001		116	-116
3	20/07/2023	FRVG-1001	550		434
4	20/07/2023	FRVG-1002	410		844
5	20/07/2023	VTR-110		300	544
6	TOTAL		960	416	544
CR-1001

Cell Formulas
Range	Formula
E2,E6	E2	=C2-D2
E3:E5	E3	=E2+C3-D3
C6:D6	C6	=SUM(C2:C5)

before

MMVO.xlsm
	A	B	C	D	E	F	G	H
2	DATE			VOUCHER NO
3	20/07/2023			VTB-123		INVOICE
4			NAME			BUYING
5			CR-1000					TOTAL
6								200
VOUCHER

MMVO.xlsm
	A	B	C	D	E
1	DATE	DETAILS	DEBIT	CREDIT	BALANCE
2
3
4
CR-1000

expected

MMVO.xlsm
	A	B	C	D	E
1	DATE	DETAILS	DEBIT	CREDIT	BALANCE
2	20/07/2023	STVG-1000		210	-210
3	20/07/2023	VTB-123	200		-10
4	TOTAL		200	210	-10
CR-1000

Cell Formulas
Range	Formula
E2,E4	E2	=C2-D2
E3	E3	=E2+C3-D3
C4:D4	C4	=SUM(C2:C3)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Extract data from multiple sheets to multiple sheets based on date(today)
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.