How to create a workbook where the master data filters to a specific worksheet

[GreenV3]

Hello, can anyone provide guidance on how to set up a housing verification workbook where the master list filters automatically to the specific housing community worksheet when entered?

[#2]

@GreenV3 

If you have Microsoft 365 or Office 2021, you can use the FILTER function