filter data copy from multiple sheets based on sheet name and brand

[leap out]

hi
i search so much to filter data based on sheet name and brand but i do not find any thing so far what I want when write in sheet1 in cell g2 = sheet name and h2 = brand in column b for all sheets the sheets call(1,2,3 .. and so on) then bring data based on sheet name and brand and if g2=empty and fill in h2 then bring he data for all sheets
this is my data for all sheets the same range

اظهار .xlsm
	A	B	C	D	E
1	date	brand	batch	invoice no	q
2	01/01/2020	12-00bsj	asd-j1	IN1000	10
3	02/01/2020	12-00bsj	asd-j2	IN1001	12
4	03/01/2020	14-00bsj	asd-j3	IN1002	34
5	04/01/2020	12-00bsj	asd-j4	IN1003	54
6	05/01/2020	16-00bsj	asd-j5	IN1004	23
7	06/01/2020	12-00bsj	asd-j6	IN1005	12
8	07/01/2020	12-00bsj	asd-j7	IN1000	34
9	08/01/2020	12-00bsj	asd-j8	IN1001	56
10	09/01/2020	16-00bsj	asd-j9	IN1002	78
11	10/01/2020	12-00bsj	asd-j10	IN1003	12
12	11/01/2020	18-00bsj	asd-j11	IN1004	23
13	12/01/2020	12-00bsj	asd-j12	IN1005	45
14	13/01/2020	12-00bsj	asd-j13	IN1006	6
15	14/01/2020	19-00bsj	asd-j14	IN1007	7
16	15/01/2020	12-00bsj	asd-j15	IN1001	89
17	16/01/2020	14-00bsj	asd-j16	in10032	9
18	17/01/2020	14-00bsj	asd-j17	in10033	12
sh1

I hope somebody help
thank in advance

 

[leap out]

any help ?

 

[leap out]

crossed posted
filter data copy from multiple sheets based on sheet name and brand