How to make a macro to be able to run in other workbook?

[solartorch]

Hi all I have a very quick question here. I have this code as attached to auto filter the data by the criteria in the code. However it can only run the filtering when the data is in the same workbook as this code.
There must be somewhere in the code that I can change to make it applicable to other workbook right? Please enlighten me, thank you very much!