Copying data from one worksheet to another

I have two worksheets. Each worksheet contains a list of programs and each item in the list can have one or many associated sub-items, these sub-items are listed below and to the right as in the following example. (Unable to post excel sample here - see additional details sheet) The second worksheet is similar (many of the items listed are repeated) but the types of data held for each item is different. I would like some VBA to go through each item in the list and check if this item exists in the second worksheet. If it does I would like all the rows belonging to this item to be cut and inserted back in the first sheet in the row below. I'm available for any questions. There is a short turn-around on this. ## Deliverables Sheet 1 <colgroup> <col width="93" span="2" style="width: 70pt;" /></colgroup> | ZZ23 | | | | ZZ2301 | | | UA0301 | | | UA0302 | | | FAIRLE05 | | ZZ24 | | | | ZZ2401 | | ZZ45 | | | | ZZ4501 | | ZZ48 | | | | ZZ4801 | | | GA5VS | | ZZ61 | | | | ZZ6101 | | ZZ62 | | | | ZZ6201 | Sheet 2 contains <colgroup> <col width="64" span="2" style="width: 48pt;" /></colgroup> | ZZ33 | | | | SARSITEM | | | SARSITEM | | | SARSROOT | | | SARSROOT | | ZZ34 | | | | RPTSOSAR | | | RPTSOSAR | | | RPTSROOT | | | RPTSROOT | | ZZ61 | | | | ASRSCOMM | | | ASRSCOMM | | ZZ62 | | | | REPSBILL | | | REPSBILL | | | REPSROOT | | | REPSSPRD | | | REPSSPRD |