How to have a drop down item generate text in a form based on text from different form.

I am trying to have an item from a drop down form take data from one form field and copy it to a different form field. Hopefully with some organization.

I am making a custom character sheet for an RPG. I would like to have 2 different inventory sheets. The first sheet tracks items based on where they are on the character. (Backpack, pouch, coin purse, etc.) The second sheet organizes the items by type. (Weapons, treasure, potions, etc.) However, I do not want to enter in the data manually. I want to enter the data in one of the sheets, and it will auto fill the other.

So, lets say I have a backpack with several text form fields to enter in items, and then next to each text item is a dropdown list that has options for the type of item. I have an item called HAMMER that I type into the text form. I then select the dropdown item WEAPON. 

Then, the text that is HAMMER will generate on the second inventory sheet, under the dedicated WEAPONS text form box. 

Ideally, several selections from various forms will be able generate text in the same text box, and perhaps be sorted alphabetically. 

I have provided the file example. It is mostly just a visual representation of what I want the end result to look like. At least as a draft. 

The complex example includes multiple text forms combining into 1 line of text. I'd be interested to know if this is possible but I am not adamant in implementing this.