Filtering data and posting results to another sheet

I would like a macro asking for “beginning” and “ending” dates, then asking for “Car Make”

Based on the result, on sheet2, starting on cell B6, show the result, which would include: the Make, Date, Region No, S or H, and the number sold, along with the total, but not to show zero or empty cells.

Allow the user to edit sheet2 (highlight, comment) print it, clear contents, etc.

Can any such macro, then retain the dates (until the workbook is closed), so if the macro is called again, it would ask “In the same period, what Make would you like to report on” and then repeat the process.