copy data from multiple sheets to one sheet based on dropdown and summing values

[Alaa mg]

hi

I have many sheets and each sheet have the same structure and every time I add a new names and data and add a new sheets , so what I want in sheet RESULT merge all of data and summing the values for specific columns COL B,E,F,K,L,M as you see in all of sheets sometimes repeat the names then should merge and summing the values and sometimes the name is existed in sheet but not are existed in other sheet so it should copy to the bottom in sheet result so it should all of data in all of the sheets merge and summing the values so if that's possible create the headers based on the sheets and bring the data as in sheet result

so if that's not clear or need attach the file just inform me

sheet1

1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ITEM	NAME	NUMBERS OF HOURS	WAGES	CASE		0.12	0.03	1.00	1.00	1% SUIT	UNITED TAXES	TAX1
2					PAID	UNPAID
3	1	ALI MOHAMEED	11	12	1	1	1	1	6	4	45	1	1
4	2	ABDULQASEM	12	23	3	3	3	3	7	5	78	3	3
5	3	ALSA ALDEEF	5	5	24	10	81	37	9	0	34	87	78
6	4	AHMED OMAR	6	6	90	11	82	38	10	21	87	10	56
7	5	MOHAMMED ALI	7	7	87	12	83	39	11	13	98	57	45
8	6	MAHMOUD	8	8	45	13	84	40	12	34	14	46	34
1

sheet2

2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ITEM	NAME	NUMBERS OF HOURS	WAGES	CASE		0.12	0.03	1.00	1.00	1% SUIT	UNITED TAXES	TAX1
2					PAID	UNPAID
3	1	ALI MOHAMEED	3	3	3	3	3	3	7	5	78	3	3
4	2	ABDULQASEM	45	76	24	10	81	37	9	0	34	87	78
5	3	ALSA ALDEEF	45	45	90	11	82	38	10	21	87	10	56
6	4	AHMED OMAR	45	34	87	12	83	39	11	13	98	57	45
7	5	MOHAMMED ALI	45	34	45	13	84	40	12	34	12	46	34
8	6	KHALID ALI	22	47	88	11	10	20	30	10	0	46	34
2

sheet3

3.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ITEM	NAME	NUMBERS OF HOURS	WAGES	CASE		0.12	0.03	1.00	1.00	1% SUIT	UNITED TAXES	TAX1
2					PAID	UNPAID
3	1	ALI MOHAMEED	34	67	68	89	90	67	54	67	78	34	67
4	2	ABDULQASEM	35	68	69	90	3	3	3	3	3	3	0
5	3	MAHMOUD SALEM	36	69	70	91	45	34	56	12	45	32	69
6	4	SALEM ALI	37	70	71	92	45	76	24	10	81	37	70
7	5	SALEM OMAR	38	71	72	93	45	45	90	11	82	38	71
3

sheet result

r.xlsm
	A	B	C	D	E	F	G
1	ITEM	NAME	CASE		1% SUIT	UNITED TAXES	TAX1
2			PAID	UNPAID
3	1	ALI MOHAMEED	72		201	38	71
4	2	ABDULQASEM	3	3	115	90	148
5	3	ALSA ALDEEF	24	10	121	97	134
6	4	AHMED OMAR	90	11	185	67	101
7	5	MOHAMMED ALI	87	12	110	103	79
8	6	MAHMOUD	45	13	14	46	34
9	7	SALEM ALI	71	92	81	37	70
10	8	KHALID ALI	88	11	14	46	34
result

 

[Alaa mg]

sorry I forgot add an important detail , the dropdown by data validation in J2 linked with COL B in sheet result also if I s elect specific name then should merge and sum the only selected from dropdown and if the dropdown is empty then merge and sum all the names

r.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ITEM	NAME	CASE		1% SUIT	UNITED TAXES	TAX1
2			PAID	UNPAID
3	1	ALI MOHAMEED	72		201	38	71
4	2	ABDULQASEM	3	3	115	90	148
5	3	ALSA ALDEEF	24	10	121	97	134
6	4	AHMED OMAR	90	11	185	67	101
7	5	MOHAMMED ALI	87	12	110	103	79
8	6	MAHMOUD	45	13	14	46	34
9	7	SALEM ALI	71	92	81	37	70
10	8	KHALID ALI	88	11	14	46	34
result

Cells with Data Validation
Cell	Allow	Criteria
J2	List	=$B$3:$B$10

 

[Alaa mg]

is there any help?