How do I double-iterate through the elements according to the hierarchy?

Roket March 5, 2021, 1:19pm 9

How to combine data from different sheets with replacement of column names on the fly?