Database Reference - IF, OR - Multiple Sheets

I'm trying to get the tool description and tool code to appear on the ET-XXX pages, in their respective columns, when I select which one I'm assigning it to from the drop down menu. But it also needs to remove and transfer to another sheet when a different selection is made in the drop down menu, without leaving the cell empty on the sheet it's removed from. I'm not even sure if this is possible, I've stumped all of my guru's. See attached, please help!Tool Inventory Proto. - Forum.xlsx

Thanks for the response. The dropdowns are on the "Tool Name" tabs, i.e. - Bending & Threading Tools, under the Truck/Trailer header.

Example: On the "Bending & Threading Tools" tab, I select "ET-001" from the dropdown. I want "Threading - Ridgid #700" from A11 to populate on the ET-001 sheet. In addition to that, I want the tool code "PP-001" from C11 to populate on the ET-001 sheet in it's respective cell.

So if I go through the entire inventory side of this book and assign tools from the dropdowns, all of the enclosed trailers "ET-XXX" and work trucks "WT-001" will have a complete list of what is in their inventory assignment.

The part everyone struggled with is, if I go back to PP-001 and select ET-002 from the dropdown, it needs to be removed from the ET-001 sheet, delete the empty row and populate on the ET-002 sheet.