Copy data from a certain range and past multiple times.

I have a range of data that requires to be copied and pasted below each other a huge number of times. Each set of data has cells in it that are linked to cells in a single row of a particular master spreadsheet. Each time the data is pasted the linked cell row number has to increase by one to input the data from the next row.
I have attached a sheet to show how I need the sheet to be.
The first range contains all the linked data in the correct cells.
I can copy and past the data as done here and then use the replace command to change the row numbers but there must be an easier way .Can anybody help.