need a macro to find single cell, copy multiple following columns from one sheet and paste it into another sheet

need a macro to find single cell, copy multiple following columns from one
sheet and paste it into another sheet

in a workbook i m having 2 sheets one is the summary sheet and other is a
detailed sheet i need to update the summary sheet according to the changes
made in detailed sheet for that i need to do following tasks 1) i need to
find a perticular cell which is in summary sheet in detailed sheet for
example XXX is a cell in summary sheet i need to find XXX in detailed
sheet 2) i need to pull the row no's after cell XXX till it gets a row in
second column which is blank
example xxx 123 1 123v 2 123 3 435 4 342f
yyy 123 1 123v 2 123 3 435 4 342f 5 in the above table i need the row no
from 123 to 242f
3) I need to copy these row no into summary sheet as a formula to count no
of rows in the row where XXX is present