Drop Down Menu For Sections

no but sort of.  So cell formulas can NOT move data, they can only show the result of a calculation/formula.

To actually move data you would have to use VBA/macro or use a Script.

That said, I would recommend what you CAN do is have a master table to ENTER data and then multiple OUTPUT tables.  Those output tables could use cell formulas or pivot tables or power query.  So the INPUT table would contain all the input data.  NOTE the "input" table could be multiple tables.  So you could have a personnel table that has their ID#, name, address, job, etc... and then another table could be Work Hours and have their ID, Date, and hours worked.  The idea is that you set up input tables that contain all the information.  So the 'Office' info could be on the personnel table I noted above or could be its own table if you want to track when they move from 1 office to another office.

Then you can create the 'report' format where you query the relevant data accordingly.  In the simple case where the 'office' is a column in the personnel table above then when you change that value the output tables for each 'office' would automatically update and "move" that person accordingly.