If it were me, I'd have a list of worksheets in a separate Config worksheet, in the order they need to be processed/attached to the report. Making it external to the code makes it easier to amend/update.

I'd read that list into an array and then loop through it. You can then add an appropriate header at the bottom and copy and paste the rows following it. That saves having to keep working out how many rows there are and inserting them.

But that's just me

Regards, TMS