I have a column of data a1:a1000, I need to copy the section between the unique cell '========' and '#######' to another worksheet.

A

1 asdfasf
2 aqwerqwreqwr
3 axcvzxcvzxcv
4 ahjgjfgghjghj
5 ========
6 klkjljlkljl
7 kljlklkll
8 kljlkllkii
9 #######
10 rasfsf
11 rasasfsaf
12 rcxcbcxb
13 rdfghhgdfg


How do I get a copy or reference to the 'k' cells to another worksheet, when the number of cells is variable (the number of 'a' cells and 'k' cells is different)?

I keep running into this type of problem and keep getting stumped.