Assigned ships for each fleet

Good day! I wanted to make my life easier on monitoring the people in each fleet of the company. So in the vessel column, I would choose the vessel name and I wanted to have an automatic input in the Fleet the column. Each ships name and the current fleet it's in is listed in sheet 4. I hope you could help with me this. Thank you and have a good day!!