Suggestive way to make the spreadsheet simpler by using calendar drop down

Hello,

I'm working on a report that contain so many information based on weekly basis. My question is if there's a way to consolidate this report but still have all the information. The report shows data on each week ending. Is there anyway that we can make a calendar drop down so the user can only click on the specific week they want to see the information like a pivot table as far as making the worksheet looks better and less size. If you have any suggestions, please feel free to recommend. Assuming there will be a thousand of data in actual file

please see me enclosed file.

Thank you for your help.sample.xlsx