Looking at your new format, i dont think we can go with the "merged cells" concept to understand if we need to insert more rows, because you have the "Date Identified" column which needs to be populated too.

I guess, we will have to go with a fixed number of rows for each section. For e.g. We will need to fix the number of rows as say 8 or 10. The macro then needs to check if the number of rows are enough to populate the data, if yes proceed, if no, insert rows and then proceed.

Where is the date column in each tab that needs to be pulled up into the main sheet?