Filter data from a sheet using a list as criteria

Hello, I wonder if this situation could be solved without VBA, but who knows? So here's the problem:

There's "Sheet1", which has several names of different companies in column A. Then, there're other two different columns in there (B and C); one where you write people's names, the other one the e-mail addresses. Most of companies have different people working there, so it's not uncommon to find more than 1 row for every company name.

Ok, so there's also "Sheet2". This one has a single column (A), containing a certain name of companies, I mean, not all of those that you can find in "Sheet1". But the idea here, it'd be to import all the data from "Sheet1" (like filtering A,B,C from "Sheet1"), using only the names of these particular companies that are present in column A in "Sheet2", as criteria. I mean, is it even possible to automate this process like this?

It's perfectly possible doing it manually, but considering the volume of data, optimizing would definitely help a lot. If anyone has a suggestion, I'd be really thankful. Nonetheless, thank you for taking your time to come here!

Maybe, we need to get his feedback

Hello nankw83, thank you for your reply!

What I need to do in this case, is like karmapala mentioned below. In that case, I need to filter all the data related to the names of these specific companies, like all the workers / contacts in company "AAA", for example

Hello, karmapala, thank you for your reply!

It's kinda like that! I'll follow xladept's advice below and attach the file to provide an idea of what I'm hoping to achieve

Hello, xladept! Thank you for your reply!

I've followed your instructions and made a quick sheet to demonstrate what I'm hoping to achieve. Please tell me if it's good enough to illustrate the idea. Thanks!

Hi Zenarte,

Maybe something like this ?

Please Login or Register  to view this content.

To test the code, please clear the cells content in Sheet2 from C4 to E12 first.

Hello again, yeah, it works fine indeed, thanks for your feedback, nankw83!

Wow, it perfectly works! Thank you very much for helping me out with this problem, karmapala!

You're welcome, Zenarte.
Glad I can help .

Originally Posted by Zenarte

it works fine indeed, thanks for your feedback, nankw83!

You are welcome, glad to help & thanks for the reps