Same Filter applied to two different excel sheet. Filter is in from distinct value of one column

[lund1234]

First Excel Sheet

Id	Name	Dept
1	Jack	IT
2	Jill	HR
3	Mary	IT
4	Rosy	Payroll

<tbody>
</tbody>

Second Excel Sheet

Id	Location
1	Melbourne
2	London
3	Melbourne

<tbody>
</tbody>

I have above two excel sheet.
The common column between these two excel sheet is "id"

What I want to do is

1. Filter based on Location in Sheet 2.
2. When I filter base on location in sheet 2 filter is automatically applied to sheet 1.

I need to keep both the sheet separate .


Thanks in advance. I am sql guy and new to excel

 

[lund1234]

Sorry to say I have important project deliverable bcz of this.
Kindly help me