Excel doubt

Dear Excel Experts, I need to give a daily report to our management for all 21 stores and the information is there in excel. Please find the attachment. "Daily report" is the second sheet in excel which I need to give on daily basis without changing the format. If I give a date in "Daily Report" sheet then total invoices numbers and amount shall come taking input from first sheet i.e "Sales". I've actually tried a lot and finally seeking your help.

Thanks in advance.