Merging data from two sheets into one

[Terrible]

Hi,

I've got to merge data from two worksheets into one, here are examples from both:
sheet 1

Excel Workbook
	E	F
4794	ZZ23	*
4795	*	ZZ2301
4796	*	UA0301
4797	*	UA0302
4798	*	FAIRLE05
4799	ZZ24	*
4800	*	ZZ2401
4801	ZZ45	*
4802	*	ZZ4501
4803	ZZ48	*
4804	*	ZZ4801
4805	*	GA5VS
4806	ZZ61	*
4807	*	ZZ6101
4808	ZZ62	*
4809	*	ZZ6201
Model_Structure

And from sheet 2:

Excel Workbook
	A	B
1	*	MCTSROOT
2	ZZ33	*
3	*	SARSITEM
4	*	SARSITEM
5	*	SARSROOT
6	*	SARSROOT
7	ZZ34	*
8	*	RPTSOSAR
9	*	RPTSOSAR
10	*	RPTSROOT
11	*	RPTSROOT
12	ZZ61	*
13	*	ASRSCOMM
14	*	ASRSROOT
15	ZZ62	*
16	*	REPSBILL
17	*	REPSBILL
18	*	REPSROOT
19	*	REPSSPRD
20	*	REPSSPRD
Sheet1

(excel jeanie put the stars in there)

So I need to go through column E and look for an equivalent in sheet2, if I find one (say (ZZ61) then all the rows for ZZ61 (so the rows beneath up to where ZZ62 starts) should be copied (or better still cut) and inserted beneath ZZ61 in sheet 1.

It would be really good though if the data from sheet 2 was cut as that way I could find the data needs to be brought over (where there was no match) easily.

If this has been done or something similar can you point me to it so I can have a look and try and hack something from it to work for me.

Thanks,

Anthony

 

[Terrible]

Just to add that the first sheet should look like this after the VBA is executed:

Excel Workbook
	M	N
4593	ZZ23	*
4594	*	ZZ2301
4595	*	UA0301
4596	*	UA0302
4597	*	FAIRLE05
4598	ZZ24	*
4599	*	ZZ2401
4600	ZZ45	*
4601	*	ZZ4501
4602	ZZ48	*
4603	*	ZZ4801
4604	*	GA5VS
4605	ZZ61	*
4606	*	ASRSROOT
4607	*	ASRSCOMM
4608	*	ZZ6101
4609	ZZ62	*
4610	*	REPSBILL
4611	*	REPSBILL
4612	*	REPSROOT
4613	*	REPSSPRD
4614	*	REPSSPRD
4615	*	ZZ6201
Model_Structure

Any pointers or tips would be gratefully received.

Thanks,

Anthony