I need the vba code that will look at the 2 headings and extract the data between them. I have attached a picture below. In the picture below I am wanting it to extract all of the data between Heading 1 and Heading 2 and then copy it to a new sheet. So in this case, all the data between Heading 1 and Heading 2 called data gets copied to Sheet 2 and so on.

Heading 1 2 data data data data data data 3 data data data data data data 4 data data data data data data 5 data data data data data data 6 data data data data data data 7 data data data data data data 8 data data data data data data 9 data data data data data data data data data data data 10 data 11 data data data data data data Heading 2 12 13 data data data2 data2 data2 data 14 data data data2 data2 data2 data 15 data data data2 data2 data2 data 16 data data data2 data2 data2 data 17 Heading 1 2 data data data data data data 3 data data data data data data 4 data data data data data data 5 data data data data data data 6 data data data data data data 7 data data data data data data 8 data data data data data data 9 data data data data data data data data data data data 10 data 11 data data data data data data Heading 2 12 13 data data data2 data2 data2 data 14 data data data2 data2 data2 data 15 data data data2 data2 data2 data 16 data data data2 data2 data2 data 17