I'm creating am monthly revenue model on excel that I hope to be automated. It feeds off a big master data file with many columns of information like name, revenue, deal ID, products etc etc.

The problem is ecah month I want to automatically extract only the rows of information that I need for particular names. I know I could obviously go inside the master file and manually filter for the client names I need but I want an automatic way of doing this - so the master data file just has to be downloaded then the other spreadsheet automatically extracts the rows of data I need for the particular list of names I have.

I'm sure there's an easy solution. Thanks in advance.