Macro to look thought multiple folders and subfolder for specific file name and aggregat

Hello

any help or direction to recourses or YouTube will be appreciated to help me in resolving below

I need to aggregate multiple xls files with specific name from multiple folders and subfolder into one file.

I receive multiple reports every day that are saved with in folder with Date in the file name
there is saving logic is :
Fund Name > Year> month > Date (05.05)> bank name> IncomeStatement21361321.xls

Aggregation file is saved in Year folder with Name (YTD PNL.xls) i need Excel to look thought all folder and to find xls file that contain IncomeStatement in the file name. ( there are PDF and xls File with same name) and then merger it into (YTD PNL.xls).

Thank you in advance for your help

If the addin approach doesn't work for you, post a sample file as per the yellow banner above so we can see its structure and recommend a solution.