Hello @E.S.7.9 ,
Unfortunately, there is no automatic way to filter out only rooms that are visible on a sheet.
As Rooms are mostly in linked files I would suggest to place Spaces and use the Space Naming tool to synchronize the Room Name and Number from the linked file.
Then create several Space Schedules and filter by Level and place those schedules on your sheet.
You could also add an extra parameter to your sheet to filter only sheets that are on a specific sheet.
Like 'On Sheet Number' as a Text parameter.

Hope this helps.
If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!
Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV