how to auto "copy & paste" (or filter) from a Master spreadsheet?
 

I am looking to €œauto filter" or "auto copy & paste" from a "Master"
Spreadsheet on to another spreadsheet. Ex: I have a "Master" for all "Live"
and "Completed" jobs, but I need to have a separate sheet with the
"completes". How Can I do this without copying and pasting every time I enter
a new location? I need it so that I can just update the "Master" and it will
automatically copy and paste it (or filter it) through.
Any help would be appreciated.

Thanks,
Armando