Manic copy and paste to new wb

[MartinL]

Can anyone pick the bones out of this.
I need to create a new sheet from a massive database created sheet.
I have grouped the data blocks as It is not obvious.
The highlighted cells need to be copied to a new sheet.
Any ideas

example data

Excel Workbook
	A	B	C	D	E	F	G	H
1	A&B Sales Orders
2	PREMIUM
3
4					16-Nov-09	17-Nov-09	18-Nov-09	19-Nov-09
5			A&B (MAYLANDS)	Trays	51	0	0	0
6		Actual	Total	Trays	51	-	-	-
7	AB Asp Spears 200g X006	Total	Trays	51.00	0.00	0.00	0.00	51.00
8	1028	Total		Trays	51	0	0	0
9			Trays	51.00	0.00	0.00	0.00	51.00
10			A&B (CUMBERNAU	Trays	47	30	39	0
11			A&B (CREWE)	Trays	50	45	85	0
12			A&B (BARNSLEY)	Trays	43	42	66	0
13			A&B (BRISTOL)	Trays	30	41	59	0
14			A&B (FAVERSHAM	Trays	68	57	101	0
15			A&B (MAYLANDS)	Trays	0	46	87	0
16			A&B (IRELAND)	Trays	22	21	18	0
17		Actual	Total	Trays	260	282	455	-
18			A&B (CUMBERNAU	Trays	0	0	0	39
19			A&B (CREWE)	Trays	0	0	0	46
20			A&B (BARNSLEY)	Trays	0	0	0	36
21			A&B (BRISTOL)	Trays	0	0	0	36
22			A&B (FAVERSHAM	Trays	0	0	0	48
23			A&B (MAYLANDS)	Trays	0	0	0	42
24			A&B (IRELAND)	Trays	0	0	0	15
25		Program	Total	Trays	-	-	-	262
26	AB Asp Spears 200g X008	Total	Trays	260.00	282.00	455.00	262.00	1,259.00
27	1025	Total		Trays	260	282	455	262
28			Trays	260.00	282.00	455.00	262.00	1,259.00
29			A&B (THATCHAM)	Trays	19	27	26	0
30			A&B (FAVERSHAM	Trays	39	29	43	0
31			A&B (HEMEL)	Trays	40	33	54	0
32			A&B (IRELAND)	Trays	9	9	7	0
33		Actual	Total	Trays	107	98	130	-
34			A&B (THATCHAM)	Trays	0	0	0	24
35			A&B (FAVERSHAM	Trays	0	0	0	31
36			A&B (HEMEL)	Trays	0	0	0	33
37			A&B (IRELAND)	Trays	0	0	0	7
38		Program	Total	Trays	-	-	-	95
39	AB Asp Tips 100g X016	Total	Trays	107.00	98.00	130.00	95.00	430.00
40	11043	Total		Trays	107	98	130	95
41			Trays	107.00	98.00	130.00	95.00	430.00
Sheet1

example output from above data

Excel Workbook
	A	B	C	D	E	F
45			16-Nov-09	17-Nov-09	18-Nov-09	19-Nov-09
46	1028	Actual	51	-	-	-
47	1028	Total	0.00	0.00	0.00	51.00
48	1025	Actual	260	282	455	-
49	1025	Program	-	-	-	262
50	1025	Total	282.00	455.00	262.00	1,259.00
51	11043	Actual	107	98	130	-
52	11044	Program	-	-	-	95
53	11045	Total	98.00	130.00	95.00	430.00
Sheet1

Martin