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