Source data has header titles on different rows

My issue is the following: Imagine you have 5 files with each file having a worksheet with the the same report. But the reports are not structured the same way. File 1 has the report title starting ...