I want to create a simple spreadsheet where Row 1 is text headings and rows
2 to xx is data copied from columns of another spreadsheet.

The final row xx, can be variable - although it will be the same for all
columns.

I vaguely remember seeing a post that used an INDEX command as a solution to
fill rows 2 to xx - but can't find it.

Can anyone help with a solution

TIA

Rob