Please excuse my lack of clarity. Using the HDR and DATA terms of
reference, a typical 6 row  'record' would be in this layout within the
worksheet

row1: HDR HDR HDR HDR HDR HDR HDR HDR
row2: DATA in all cells  to cell O2 inclusive
row3: DATA in all cells to cell O3 inclusive
row4: DATA in all cells to cell O4 inclusive
row5: DATA in all cells to cell O5 inclusive
row6: DATA in all cells to cell O6 inclusive

and there'd be a blank  row in row7 between the record  and the next one
in the worksheet.

Intended result is to have row1 appended to rows  2 to 6 by copying
cells A1:A8 and pasting  to P2:W2 and then copying  that down to P6:W6

The problem  for me is that the records  can be six rows deep (as in the
above example) or five rows or four rows so a simple copy  and paste is
not the best way. There are about a thousand different records in the
worksheet and they each have a single  blank row separating them.

The actual HDRs have various content, ditto the DATA.

Thanks for taking an interest.
Hoping this will clarify rather than add  to the confusion !