Sort based on data from another sheet

[Wild Child]

Is there a way to sort data based on information from another sheet in the workbook?

I have a sheet with the current jobs for the month, I have a master list that has all jobs on it, I need to filter the second list to have the same jobs as the first list.

The above list is the monthly data, the master list below is what I need filtered. Column "D" on both sheets have the same data.

Currently I have to manually filter the list and that takes several hours for me to complete.
I am somewhat new to excel and would appreciate any help!!

 

[kanadaaa]

Use the filter function How to use the Excel FILTER function | Exceljet

 

[Wild Child]

Use the filter function How to use the Excel FILTER function | Exceljet

I am currently using the filter function but have to manually select the ones to filter out. I would like to automate the process if possible