Filter from separate worksheet

I have a "Master" worksheet with all the data.
I would like to have separate worksheets that displays all of the fields for all of the records with a matching "Location"

ie, worksheet named "loc1" will have all records matching "loc1" field from the Master, and a worksheet named "loc2" ...etc

I could also deal with a "Key Cell" on a worksheet where I would either enter "loc1", or have a pull-down listing all loc#s that would be a trigger to populate the sheet.

Updates will be to the Master sheet only.
A "refresh" button would be acceptable for the loc# worksheets.

It seems I can't relocate the filter results to a different worksheet. Is there a work around?
I don't want to AutoFilter the Master and then copy-paste to the loc# sheet.

Thanks

This looks great!

Thanks!

The code worked great!
I now have a Master sheet of all the data, and a "Site" sheet that will display the records matching the locID from a pull-down, after a button push.

Now, in trying to protect this sheet from flailing fingers, and to impress that Updates should be on the Master only, I've inserted a few "ActiveSheet.Protect" and ".Unprotect" statements.

I do have some formulas on the Master that I want to preserve, so I protected the sheet and unlocked most of the other cells.

Now when the macro runs to update the 'Site' sheet, the "unlocked" property is copied from the Master to the Site cells.

Is there a setting or switch that will keep the whole "Site" sheet protected?
Or a tweak in the "copy" code?

Thanks