I'm curious about your bosses behavior.
It sounds like you want your named range to stick with column B, regardless of what your boss cut/pastes.
Wouldn't he be adding data to the new location, requiring that the name moves with the cells.

P.S. have you asked your boss to stop breaking spreadsheets? Or, perhaps more politic, have you asked him what lay-out he likes so that you can make the master spreadsheet with a lay-out that he doesn't have to keep "fixing".