Hi ubns,
This is the first time youve mentioned headings in this thread.
For some code to process content between headings, see:
https://www.msofficeforums.com/vba/1...ific-text.html
You need to note that vba can't select multiple discontiguous ranges. So, if the there is anything between the tables, they have to be either: copied & pasted individually; or copied as a group along with the intervening content, which can then be deleted after pasting.