Userform msg box to open certain workbooks in different folders based on 2 criteria

Hello,

What I want the code to do is have a userform and message box prompt for the user. The user will select a keyword from the file names title and a monthly folder that is => whatever date they input in the msgbox.

The list of names would only ever be:
1. Nike
2. Addidas
3. Sketchers

For example, If I wanted to grab every file that had the word "Nike" in the workbook title AND grab only those same 'Nike" files if the date is => Jan-2025. Therefore the code would only open Jan-25, Feb-25 & Mar-25 for workbooks that have 'Nike" in the title.




All Months.png
Just Feb & March 25.png
Feb 25.png
Mar-25.png

Please Login or Register  to view this content.

I have revised some of the code and have attached some more workbooks.

I decided to scratch the user form ask. I have the code working below as an input box & the user enters the file path and then it searches for keyword within filename. It works! pulls up all the Opened files within the folders for lets
say 'NIKE'. But now I want to copy a specific range from all the open files that have an 'Inventory' sheet. I want range D42 to last row in column D where data is present. Then paste that to the first available row
in sheet 'Log' in the master Inventory workbook. Any ideas how I can make that happen?



User input box - Choose keyword in title.png
User input box - Choose month equal and greater than.png

Please Login or Register  to view this content.

I could not attached the Log file with VBA in it b/c of file size. So I attached a copy of it w/o VBA.