VBA Find Dynamic Range based on Cell Borders then combine to one cell

Hi all reaching the limits of my VBA skills and would appreciate some guidance

Here is my problem, in two parts

1)
I have a report which I am trying to extract data from.
There are two sections (Notes A & Notes B in the sample workbook) which always start at the same range, but could be any number of rows down.

I figured that using the border formatting between the notes would be the easiest way to define the range, but I don't know how to code it.

(I have named the ranges in my sample file purely to make it easy to see which data i am trying to extract)

2)
Once the range is defined, I then need to copy the range values into one cell, line breaks in tact.

That is, to give the same result as this code:

Please Login or Register  to view this content.

Thanks, Ivan