Sales Summary Excel Spreadsheet

I need an excel spreadsheet that will import text files from a folder and generate sales reports and data based on dates that the user chooses. I imagine it will use VBA. I'm currently writing the app that generates the text files, so there is some flexibility on formatting the text files themselves. The Excel file should: * import all tab delimited text files in a folder (a subfolder below the xlsx file) * This data will be imported into the first sheet (or two) * provide the user the ability to choose dates/times on the 2nd or 3rd sheet * provide reports such as total sales, category sales, etc. This is not a data entry job. I'm looking for a file that updates whenever new files are copied to the data folder. I've included some sample data for you to look at. As I said earlier, There is some flexibility in the formatting of the data files, If we work together I will solicit advice from you on the best way to write the data files. The folder this file will work with may contain hundreds of files, so the solution needs to work with that.