Excel

Hello, I am looking for a way to have a single sheet comprising records on different dates. i.e. sheet 1 consists of a monthly school register with a Date & Year list data validation cell currently showing for Oct. 2023. Is there a way I can have the sheet give me MoM reports by just changing the date?