lookup specific text, then apply rules
 

I need some code that will allow me to search for the word "CANCELLATIONS",
then take that line and every line following it until a blank cell appears.
Then I need it to copy that text to 'Sheet3', and continue the search for any
other "CANCELLATIONS" that exist within the sheet...and do the same thing for
the rest of the sheet.... NOTE: all data being searched is in column "A".

Any help is appreciated,

JB