Good afternoon. I would like to create a sheet (formula) that would scan another sheet for customer name matches.

I would like to have a Master Excel Sheet with the names of companies that I work with (i.e. XYZ Corp)

I receive Excel sheets daily for work that will be done that impacts hundreds of customers. I'd like to be able to match these sheets with my Master sheet to see if any of my customers are impacted. I would rather do this than manually scroll through these sheets (or use a filter) to see if my customers are on the list.

Vlookup? Macro?

Thanks in advance

Note: All the daily work sheets display the customer name in Column A