filling values for transposed data horizantly from sheet to others based on headers

[Mussala]

Hello
I want matching items in column B for sheet DATA with others sheet for headers in row 1 then should fill values under headers and dates based on matching sheet name MONTH for each sheet add Total row for each month . every month

sheet data

JOURNAL.xlsx
	A	B	C	D	E	F	G	H
1	2009 JAN		JOURNAL
2	date	ACCOUNT NO	describe	DIFF	TOTAL		DEBIT	CREDIT
3	1/1/2019	account1	EXPENSES	0.00	0.00	0.00	2000.00
4	2/1/2019	account1	BANK					400.00
5	3/1/2019	account2	BANK					200.00
6	2/2/2019	account2	SAFE	0.00	0.00	0.00		1000.00
7	3/2/2019	account 3	EXPENSES	0.00	0.00	0.00	1200.00
8	4/2/2019	account 4	SAFE	0.00	0.00	0.00		300.00
9	5/2/2019	account 5	SAFE	0.00	0.00	0.00	400.00
10	6/2/2019	account 6	SAFE	0.00	0.00	0.00	500.00
DATA

Cell Formulas
Range	Formula
D3,D6:D10	D3	=F3-E3
E3,E6:E10	E3	=SUMIF($F$2:$FI$2,$FI$2,F3:FI3)
F3,F6:F10	F3	=SUMIF($G$2:$FJ$2,$FJ$2,G3:FJ3)

JOURNAL.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	2009 JAN				account1		account2		account3		account4		account5		account6		account7
2	date	DIFF	TOTAL		DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT
3		0.00	0.00	0.00
4		0.00	0.00	0.00
5		0.00	0.00	0.00
6		0.00	0.00	0.00
7		0.00	0.00	0.00
8		0.00	0.00	0.00
9		0.00	0.00	0.00
JAN

Cell Formulas
Range	Formula
B3:B9	B3	=D3-C3
C3:C9	C3	=SUMIF($D$2:$FG$2,$FG$2,D3:FG3)
D3:D9	D3	=SUMIF($E$2:$FH$2,$FH$2,E3:FH3)

JOURNAL.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	2009 JAN				account1		account2		account3		account4		account5		account6		account7
2	date	DIFF	TOTAL		DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT
3		0.00	0.00	0.00
4		0.00	0.00	0.00
5		0.00	0.00	0.00
6		0.00	0.00	0.00
7		0.00	0.00	0.00
8		0.00	0.00	0.00
9		0.00	0.00	0.00
FEB

Cell Formulas
Range	Formula
B3:B9	B3	=D3-C3
C3:C9	C3	=SUMIF($D$2:$FG$2,$FG$2,D3:FG3)
D3:D9	D3	=SUMIF($E$2:$FH$2,$FH$2,E3:FH3)

result

JOURNAL.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	2009 JAN				account1		account2		account3		account4		account5		account6		account7
2	date	DIFF	TOTAL		DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT
3	1/1/2019	0.00	0.00	0.00	2000.00
4	2/1/2019	0.00	0.00	0.00		400.00
5	3/1/2019	0.00	0.00	0.00				200.00
6		0.00	0.00	0.00
7		0.00	0.00	0.00
8		0.00	0.00	0.00
9		0.00	0.00	0.00
JAN

Cell Formulas
Range	Formula
B3:B9	B3	=D3-C3
C3:C9	C3	=SUMIF($D$2:$FG$2,$FG$2,D3:FG3)
D3:D9	D3	=SUMIF($E$2:$FH$2,$FH$2,E3:FH3)

JOURNAL.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	2009 JAN				account1		account2		account3		account4		account5		account6		account7
2	date	DIFF	TOTAL		DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT	DEBIT	CREDIT
3	2/2/2019	0.00	0.00	0.00				1000.00
4	3/2/2019	0.00	0.00	0.00					1200.00
5	4/2/2019	0.00	0.00	0.00								300.00
6	5/2/2019	0.00	0.00	0.00									400.00
7	6/2/2019	0.00	0.00	0.00
8		0.00	0.00	0.00
9		0.00	0.00	0.00
FEB

Cell Formulas
Range	Formula
B3:B9	B3	=D3-C3
C3:C9	C3	=SUMIF($D$2:$FG$2,$FG$2,D3:FG3)
D3:D9	D3	=SUMIF($E$2:$FH$2,$FH$2,E3:FH3)