In the video above you can see how schedules in Revit 2023 can update based on a filter setting by adjusting the view crop region.

The image below shows the steps to make this active based on items shown on the sheet.