you've absolutely nailed the first part - I would never have come up with that code in a million years!

The only thing that I couldn't see working was if the User of a particular device changes is updated on the Master sheet. Is it possible to rerun the macro on demand to get it to update the changed user(s) on their applicable worksheet(s)?