Auto-populate data from multiple sheets into one master sheet- Help

[MThies]

I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected.
I only included the Master Sheet and 2 tabs below. Thank you for your help.

Master Sheet

Retail Audit Formbb.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Total Quality Audit Data
2	2/1/2024
3	Backstock/Shelf Rotated?	Yes	Total OOR:	22.00	Total OOC	35.75	Total Cases:	107.00
4	OOC > 30 Days?	No	OOR %:	20.56%	OOC %:	33%
5	Brand	Pkg Description	CASE QTY	BTL QTY	KEG QTY	OOR CASES	OOR BTLS	OOC CASES	OOC BTLS	OOC KEGS	OOC Date
6	BLUE MOON LIGHT SKY	2/12/12 oz CAN	5	48	1	1	24	1	28	1	2024-01-11
7	COORS LIGHT	2/12/12 oz NR	2	0	0	0	0	0	2	0	2024-02-02
8	0	0	0	0	0	0	0	0	0	0	1900-01-00
9	0	0	0	0	0	0	0	0	0	0	1900-01-00
10	0	0	0	0	0	0	0	0	0	0	1900-01-00
11	0	0	0	0	0	0	0	0	0	0	1900-01-00
12	0	0	0	0	0	0	0	0	0	0	1900-01-00
13	0	0	0	0	0	0	0	0	0	0	1900-01-00
14	0	0	0	0	0	0	0	0	0	0	1900-01-00
15	0	0	0	0	0	0	0	0	0	0	1900-01-00
16	0	0	0	0	0	0	0	0	0	0	1900-01-00
17	0	0	0	0	0	0	0	0	0	0	1900-01-00
18	0	0	0	0	0	0	0	0	0	0	1900-01-00
19	0	0	0	0	0	0	0	0	0	0	1900-01-00
20	0	0	0	0	0	0	0	0	0	0	1900-01-00
Master QA

Cell Formulas
Range	Formula
H3,F3,D3	H3	=SUM('Quality Audit 1'!H8+'Quality Audit 2'!H8+'Quality Audit 3'!H8+'Quality Audit 4'!H8+'Quality Audit 5'!H8+'Quality Audit 6'!H8+'Quality Audit 7'!H8+'Quality Audit 8'!H8+'Quality Audit 9'!H8+'Quality Audit 10'!H8+'Quality Audit 11'!H8)
D4	D4	=SUM(D3/H3)
F4	F4	=SUM(F3/H3)
A6,A7:K20,D6:K6	A6	='Quality Audit 1'!A11
B6	B6	=IFERROR(VLOOKUP($A$6,'Quality Audit 1'!$A$11:$K$42,2,FALSE),IFERROR(VLOOKUP('Master QA'!$A$6,'Quality Audit 2'!$A$11:$K$42,2,FALSE),"Not found"))
C6	C6	=IFERROR(VLOOKUP($A$6,'Quality Audit 1'!$A$11:$K$42,3,FALSE),IFERROR(VLOOKUP('Master QA'!$A$6,'Quality Audit 2'!$A$11:$K$42,3,FALSE),"Not found"))

Cells with Data Validation
Cell	Allow	Criteria
B3:B4	List	=#REF!

TAB 1

Retail Audit Formbb.xlsm
	A	B	C	D	E	F	G	H	I	J	K
8	Backstock/Shelf Rotated?	Yes	Total OOR:	2.00	Total OOC	3.25	Total Cases:	10
9	OOC > 30 Days?	No	OOR %:	20.00%	OOC %:	33%
10	Brand	Pkg Description	CASE QTY	BTL QTY	KEG QTY	OOR CASES	OOR BTLS	OOC CASES	OOC BTLS	OOC KEGS	OOC Date
11	BLUE MOON LIGHT SKY	2/12/12 oz CAN	5	48	1	1	24	1	28	1	1/11/2024
12	COORS LIGHT	2/12/12 oz NR	2						2		2/2/2024
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Quality Audit 1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K11:K97	Cell	contains a blank value	text	NO
K11:K97	Expression	=K11<TODAY()	text	NO

TAB 2

Retail Audit Formbb.xlsm
	A	B	C	D	E	F	G	H	I	J	K
8	Backstock/Shelf Rotated?	No	Total OOR:	2.00	Total OOC	3.25	Total Cases:	7
9	OOC > 30 Days?	No	OOR %:	28.57%	OOC %:	46%
10	Brand	Pkg Description	CASE QTY	BTL QTY	KEG QTY	OOR CASES	OOR BTLS	OOC CASES	OOC BTLS	OOC KEGS	OOC Date
11	COORS BANQUET	2/12/12 oz NR	2	48	1	1	24	1	28	1	1/11/2024
12	FOSTERS	2/12/12 oz NR	2						2		2/6/2024
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Quality Audit 2

Cell Formulas
Range	Formula
H8	H8	=SUM(C98:E98)
D8	D8	=SUM(F98:G98)
D9	D9	=SUM(D8/H8)
F8	F8	=SUM(H98:J98)
F9	F9	=SUM(F8/H8)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K11:K97	Cell	contains a blank value	text	NO
K11:K97	Expression	=K11<TODAY()	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A11:A97	List	='Data Source'!$A$2:$A$109
B11:B97	List	='Data Source'!$C$2:$C$33
C11:F97	Whole number	>=0
H11:J30	Whole number	>=0
H8	Any value
B8:B9	List	Yes,No

 

[alansidman]