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

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.