Search and sum values in multiple workbooks for accounting

[Petijandro]

Dear Excel Gurus,

I looked through the forums to try to find a solution for this problem but was not lucky.

I'm trying to put together a search box that can loop through all the workbooks in a folder and all the subfolders and find all occurences of that search string and copy them over to a sheet with all the adjacent data (2-3 columns to the right).
This search box would have a Date interval so it would only consider data within that date range.

.
This is how all workbooks look like, we have sheets for every week where our colleagues can track their progress on that specific workday (sheets called "Week 24", "Week 25" etc):

And this would be the end result:

I am just wondering if this is possible in Excel?
I have some basic vba skills and managed to put together the search function that loops through the workbooks but cannot figure out how to work with the dates.

All advice are greatly appreciated.

Thank you ?

 

[Petijandro]

I did not mention that we are working on Office 2019, sorry about that. But you gave me a very good lead and I shall continue on that path.
Your solution is great and working.
Thank you very much.

 

[Radoslaw Poprawski]

you still can do that filter data. its just way more complicated without the filter function.

If you think you can handle advanced array formulas MR excel and Mike Girvin ExcelIsFun on Youtube have at least 10 episodes on data filtering.