Copy Range and Paste into new Sheet

[naise]

Hi, I need some help.

I have a list of information provided and I need to copy a specific range and paste it into a new sheet

RC 1
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

RC 3
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

RC 2
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

the 1 / 3 / 2 might not be in sequence

Is there a way to copy the entire information in "RC 1" till 1 row before "RC 3" and paste it into a new Sheet called "RC 1"?

 

[Fluff]

In that case can you please give an accurate representation of your data?