vba to find a header that repeats

[drop05]

Hello, using vba i am looking for a way to find a header/multiple headers, the first header is called "Test A" and starts on row A51 and has a range where values are.
The next header after that is "Test A-1" and same thing has a range of values, but that one is in column A but the row can be different depending on the values from the header Test A.
Then the headers repeat where a new entry of "Test A" and "Test A-1" can happen with new values still in column A . All in a sheet called sheet1

Is there a way to find these headers and the repeated ones?
And copy their values that are located one row below the header name and in column G so 6 columns over and paste those values into sheet2, until there is no values to copy from?
here is an example how the header and the value spaces

 

[Fluff]

Duplicate to: using a header as an identifier for an input range

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.