I think we're dealing with a major nomenclature/semantics problem
here. So it makes communication and understanding difficult.

I'll try to describe what it sounds like you're saying:

You have an excel file imported from a database  report.
The report has multiple lines per record.
The number of lines per record  is variable between 4 and 6)
Each record is separated by a blank  row.
The first line of the FILE (Report) is a header  from colunmns A-H (8
columns)

Here's where it starts to get confusing:
Each row  of a record fills columns A-O (15 columns)
"Each field  header has different text" ??huh??
You need to add  it "alongside" the record row ??huh??

Then, your example  says something about having 5 rows  of data pasted
into cells  A1-H1 and you want them ADDED to rows 2-6?

Tell you what, can you give us a simple example of a partial record?

for instance,
row1: HDR1 HDR2
row2: DAT1 DAT2
row3: HDR3 HDR4
row4: DAT3 DAT4

result:
row1: HDR1 HDR2 HDR3 HDR4
row2: DAT1 DAT2 DAT3 DAT4

or, send me a sample data set (to Pschreiner at indy.rr.com)
showing the original  data and what the result should be for a single
record and I'll see what I can do.