Dynamically identify headers in a Pivot Table and procedurally CONCAT content for XLOOKUP

I have written VBA to take one .csv file saved as an .xlsm that conditions data in the first sheet, creates a new sheet and Pivot Table, opens another locally saved .csv, conditions its data, and creates a new sheet and Pivot Table.
4 sheets in total with 2 having conditioned raw data and two Pivot Tables created using said data.
On the sheet entitled "PIVOT_GAP" I have CONCAT formulae to combine the sub-header in the Pivot Table and the following 1, 2, or 3 rows of associated data.
After the data there is another sub-header and its data and repeats until the end of the Pivot Table which will never have the same rows created nor will they be in the same order.
Currently, I manually copy + paste the CONCAT formulae that use the following system:

Please Login or Register  to view this content.

Where A4 is the sub-header and A5 is the data. For sub-headers with more than one row, each subsequent row would still reference the sub-header but use its row number as the new value:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Each row of associated data will always start with "PRESS" -

Please Login or Register  to view this content.

could be used as a check.
What I need is to dynamically add formulae that will always CONCAT the sub-header with one row of associated data in a loop, move to the next row, CONCAT the same sub-header with the new row's data, and repeat.
Every time a new sub-header is reached a new CONCAT formula is started with the appropriate "A"& row#. It will do this until the last row is reach.

I'd perform the same process on the other Pivot Table sheet and then XLOOKUP for matching values before finishing the script.
The code I wrote that is close but incorrect is as follows (part of a larger script):

Please Login or Register  to view this content.

PIVOT_GAPS.png
I attempted to attach an example workbook but I am uncertain if it worked.
Thank you in advance for your assistance!
-Mark

Your Pivot table does not show the source data that may be necessary to work your issue. Once we see the source data, it may be possible to resolve your issue in Power Pivot to concatenate Text into a single cell with a DAX measure.

In your source data, concatenate the two columns and then in your pivot, use the Immediate Owner and the Concatenated Column as your two Rows.

We need to wait for a VBA guru to jump in here. Not my forte.