Sorry, I was out of the office for the weekend, but I am back now. Your code almost works, but I think I didn't explain myself clearly enough the first time.

Master Document: The place I want to input all the new data.

Source Document: Where all the new data is drawn from.

Here is what my tables look like:

Source Document:
Row1: "Aerospace, Space & Defence"
Row2: New Data
Row3: New Data
Row4: "Agri Foods"

I want to copy all the data in between the two headings. Then:

Master Document:
Row1: "Aerospace, Space & Defence"
Row2: Old Data
Row3: "Agri Foods"

I want to paste the new data and replace the old data. Note that the number of rows under each heading varies.

Any help would be greatly appreciated! Thanks so much.