Need a vba macro to combine sheets based on date in file name

[blakecintx]

Long story short I work in a restaurant that had a TON of lotus sheets built for us. Well the times have called for us to finally ditch windows 7...and with that any and all lotus support. I've figured out the majority of our macros/scripts and managed to gets this sales_sheet to export into its own file titled "SALESDATE(MMDDYYYY).XLS". I need to create another sheet to take those files and combine them based on a date range input (ideally a popup). Pulling a sales range for say 05012024-05262024 which will combine those files to give me a single sheet. I included a screenshot of the lotus sheet we currently use to consolidate those files into one sales range.

 

[Rijnsent]

Hi blakeintx,
welcome to the forum. I'm missing your question here... Are you looking for a freelancer to build this for you? Are you in the process of building it yourself and have some coding questions? What you describe sounds very possible with either PowerQuery or VBA.
Cheers,
Koen