Multiple Row Headers and copy and pasting its corresponding data into a master sheet

[VBA learner ITG]

Good afternoon,

Thank you for reading my post.

I have imported over 1000 documents into one master document by a VBA code of copy and paste to create a database.

The database has rows of data each with their own headers and and metadata below it.


Example:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Header 1[/TD]
[TD]Header 2[/TD]
[TD]Header 3[/TD]
[TD][/TD]
[TD]Header 4[/TD]
[/TR]
[TR]
[TD]metadata[/TD]
[TD]metadata[/TD]
[TD][/TD]
[TD][/TD]
[TD]Meta Data[/TD]
[/TR]
[TR]
[TD]empty row[/TD]
[TD]empty row[/TD]
[TD]empty row[/TD]
[TD]empty row[/TD]
[TD]empty row[/TD]
[/TR]
[TR]
[TD]Header 2[/TD]
[TD]Header 3[/TD]
[TD]Header 1[/TD]
[TD][/TD]
[TD]Header 1[/TD]
[/TR]
[TR]
[TD]metadata[/TD]
[TD]metadata[/TD]
[TD]Metadata[/TD]
[TD][/TD]
[TD]metadata[/TD]
[/TR]
[TR]
[TD]metadata[/TD]
[TD]metadata[/TD]
[TD]metadata[/TD]
[TD][/TD]
[TD]Metadata[/TD]
[/TR]
</tbody>[/TABLE]


I was wondering is there a way to cycle through over 16000 lines of data in the database to find header 1 and all its data that is below it until it stops at a empty row like an index and match.