Moving values with formatting, except borders, and multi sheet formulas

[TimTows]

My apologies if this is simple. It's been 10 years since I last used excel regularly and lots has changed.

I work for a repossession company handling post recovery. I have a couple programs that will display the information I compile in excel, but I also use excel as my lot mapping interface.
Attached you'll see a sample document, with personal info scrubbed, that shows my blank lot map, one labeled with spot numbers, one filled in with sample vins, and finally the detail sheet listing vehicle specific info, all fake.

I'm going to explain my perfect functionality, but I am not requesting a step by step tutorial, unless you're really bored. I just want to know if what I'm asking is possible and where to look.

When a new vehicle comes into processing, I input last 6 characters of VIN (usually 6 numbers, occasionally first character is a letter) This creates and entry in the details sheet. When I label in details whether the vehicle has keys/drives/has full access (access to trunk and glove box to remove personal property) the text should change to the corresponding color. I should then be able to drag the the text into any other cell, including cells that have been merged and centered maintaining the text formatting, but not changing destination, or source borders.

I do the lot organization from excel mobile on android. I input details sheet on windows pc.

Any advice is awesome.
Thank you.