everyone so I am looking for the best way to do this, im working on a project for work in which 80 associates need a list that pertains to them based on accounts they handle

Example

https://imgur.com/gallery/3DRrkJe

So based on this example lets say I have Jessica who's in charge of the account number x3000-150 and z3000-150, then Tom has x1020-030, Mandy's are A1 020-01 5,Z1020-025,X3000-050. I need to have a sheet for each associate that shows the acount, region, date and amount for each line item that matches the accounts they are in charge of. Ofcourse this will be in a larger scale, the project I am working on has a total of 3000 line items. What is the most efficient way to do this?