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