Code that will select and copy only so many rows

I need code that will look for a number in cell C1 and then it starts at C9
selecting cells to copy until it sees a cell with a number larger than what is in C1 and stops.
i need code for this since the number in C1 is always changing


Example: if there is an 18 in C1 it selects all cells that are >0 and <19

these cells are always sorted 123456........36 they are not random in order like 1 17 6 12 18 4 3



I have attached a sample file so you can better understand what i am looking for. Thanks

you could use a function try
=IF(ROW()-7<=MATCH(Sheet1!$C$1,Sheet1!$C$9:$C$1000),Sheet1!C9,"")
in a8 sheet 2 dragged down as far as you think you'll need (you could increase Sheet1!$C$9:$C$1000 if you want)