Best way to compile this data with VBA

[Valthanos]

I have attached a workbook with two worksheets, Query Table (data shown below), and Breakdown.

I need to extract data from the Query Table, that is Late and not complete. That means any dates in column B, that are prior to today's date, and has a status in column G of anything other than an "X".

This needs compiled in a new sheet similar to how it is shown on the Breakdown worksheet.
For some reason I cannot figure out where to begin, let alone how to do it correctly.

Any help is appreciated.

Operation	Mfg Due Date	Job Number	Detail Number	Description	Qty Req'd	Status	Job Leader
13​	11/30/2021​	4953A503	454	Vent Pin	72	O	Rich Heberle
25​	1/10/2022​	4770A417	200	BH Cavity Block	20	I-10%	Rick Bottoni
25​	1/10/2022​	4770A417	200	BH Cavity Block	20	I-10%	Rick Bottoni
8​	1/17/2022​	5016P101	205	Ejector Sleeve	1	OUT	Eric Borland
9​	1/17/2022​	5016P101	900	Metric Stage 1 Fwd Stop Base	4	out	Eric Borland
9​	1/17/2022​	5016P101	901	Metric Stage 1 Fwd Stop Nut	4	out	Eric Borland
9​	1/17/2022​	5016P101	902	Metric Stage 1 Fwd Stop Cap	4	out	Eric Borland
9​	1/17/2022​	5016P101	920	Metric Stage 1 Back Stop Base	2	out	Eric Borland
9​	1/17/2022​	5016P101	921	Metric Stage 1 Back Stop Nut	2	out	Eric Borland
9​	1/17/2022​	5016P101	922	Metric Stage 1 Back Stop Cap	2	out	Eric Borland
9​	1/17/2022​	5016P101	940	Metric Stage 2 Fwd Stop Base	4	out	Eric Borland
9​	1/17/2022​	5016P101	941	Metric Stage 2 Fwd Stop Nut	4	out	Eric Borland
9​	1/17/2022​	5016P101	942	Metric Stage 2 Fwd Stop Cap	4	out	Eric Borland
9​	1/17/2022​	5016P101	960	Metric Stage 2 Back Stop Base	2	out	Eric Borland
9​	1/17/2022​	5016P101	961	Metric Stage 2 Back Stop Nut	2	out	Eric Borland
9​	1/17/2022​	5016P101	962	Metric Stage 2 Back Stop Cap	2	out	Eric Borland

Breakdown:

2021							Late Lines:	1
	November	​						Late Lines:	1
		Line#	Due	Job Number	Detail	Description	QTY	Status	Work Center	Job Leader
	​	1​	11/30/2021	4953A503	454	Vent Pin	72	O	Grind	Rich Heberle
2022							Late Lines:	60
	January	​						Late Lines:	29
		Line#	Due	Job Number	Detail	Description	QTY	Status	Work Center	Job Leader
	​	1​	1/10/2022	4770A417	200	BH Cavity Block	20	I-10%	Plate	Rick Bottoni
	​	2​	1/10/2022	4770A417	200	BH Cavity Block	20	I-10%	Plate	Rick Bottoni
	​	3​	1/17/2022	5016P101	205	Ejector Sleeve	1	OUT	Saw	Eric Borland
	​	4​	1/17/2022	5016P101	900	Metric Stage 1 Fwd Stop Base	4	out	Soft Turn	Eric Borland
	​	5​	1/17/2022	5016P101	901	Metric Stage 1 Fwd Stop Nut	4	out	Soft Turn	Eric Borland
	​	6​	1/17/2022	5016P101	902	Metric Stage 1 Fwd Stop Cap	4	out	Soft Turn	Eric Borland
	​	7​	1/17/2022	5016P101	920	Metric Stage 1 Back Stop Base	2	out	Soft Turn	Eric Borland
	​	8​	1/17/2022	5016P101	921	Metric Stage 1 Back Stop Nut	2	out	Soft Turn	Eric Borland
	​	9​	1/17/2022	5016P101	922	Metric Stage 1 Back Stop Cap	2	out	Soft Turn	Eric Borland
	​	10​	1/17/2022	5016P101	940	Metric Stage 2 Fwd Stop Base	4	out	Soft Turn	Eric Borland
	​	11​	1/17/2022	5016P101	941	Metric Stage 2 Fwd Stop Nut	4	out	Soft Turn	Eric Borland
	​	12​	1/17/2022	5016P101	942	Metric Stage 2 Fwd Stop Cap	4	out	Soft Turn	Eric Borland
	​	13​	1/17/2022	5016P101	960	Metric Stage 2 Back Stop Base	2	out	Soft Turn	Eric Borland