Consolidate data from an Excel sheet, starting with a specific row with text.

Dear Excel specialists,

I have a quick question regarding a VBA script. I am looking for a script that performs the following tasks:

Tasks:
1. Searches for all Excel files in a specific folder, which in this case is "C:\Temp\All_Files".
2. Opens each Excel file found in the aforementioned folder and extracts all the text starting from a specific row that contains the phrase "Provide the full application name" until the last row without text.
3. Consolidates all the collected data from each Excel file into one file, such as "C:\Temp\Consolidated.xls".

I added two sources files to show an example. The results in the Consolidated.xls file should show the rows with the text A, B, C, D, E and F

Can anybody help me with this please? I would appreciate it.
Thank you in advance.

Best regards,

Hans