I need to "message" a report from QB. Here is the layout

Each Group Title Starts at Col F with a description say "TTTTTT", the
rest of the row is blank
Each transaction for THAT title starts at the NEXT row columns H:T
Last row for this group end with "Total TTTTTT" in column Fn and a sum
for column T at column T

The next group is repeated after a blank row.

What I need is to create a new sheet that copies each group (H:T)n WITH
"TTTTTT" repeated with each transaction and make sure that the sum is
the same. Let me have a go in simulating it in ASCII !!!!

T1T1T1T1T1
H2......T2
H3......T3
Total T1T1T1T1T1 sum(T2:T3) in T4

What I need

T1T1T1T1T1 H2......T2
T1T1T1T1T1 H3......T3 and verify that sum(T2:T3)
is correct by summing it in VBA and comparing it with the last row in
the group.

I have several groups following that, and same structure.

Any Guidance will be greatfully apprecaited