VBA to paste data in next availble blank row within a range.

This is just a sheet that is used fro baseball drafting. In cells F4:M12 is data validation lists of all the kids who are 11 years old. The columns are the actual teams. So there are a total of 9 teams. In cells F13:M19 are data validation drop down boxes as well but these are of 12 year olds. So what I'm trying to accomplish is if I choose a player that is 12 years old (in cell J16) and they have a younger brother who is 11 the vlookup kicks in and will return the 11 year old brothers name in the next available blank cell (in this scenario in cell J9 since cells J4:J8 have a name in it already) in that same row. Attached is a sample file

So I am assuming you have a spreadsheet somewhere that has the sibling information listed since you refer to the vlookup kicking in. Is there a column that indicates the siblings are related? You can't just go on last name as there are often siblings with different last names. I am also assuming that if you select Billy for the Yankees and Jamie is added to the team, those 2 players should not be available for drafting on another team. What should happen if all the spots for an age group are filled when a sibling is chosen in a slot of another age. For example, lets say Billy is chosen in the 12 year old section, Jamie is his sibling but there are no more open 11 year old slots available. What should happen? What should happen if you have 2 siblings the same age? Should they go to the same team?

How are you envisioning this will work, with VBA code or with just formulas?

Sincerely,

Marty