Filtering from one table to the other

[M0X3]

I have two tables on two different tabs within a sheet. The first two columns are the same (company names and alias). One of the tables includes a lot of different filtering information such as the industry of a company. The other table contains information that's relevant to whoever is going to use the spreadsheet. My goal is to be able to use the filtering parameters in the one table to filter the table with the relevant information. If I filter the first table by industry, that doesn't affect the second table on the other tab. How can I accomplish? I have Excel 2016, so no new functions are available to me.

 

[M0X3]

Would slicers be useful perhaps?

 

[Radoslaw Poprawski]

TRy ding parametrized query.
use power query