Excel - How to build pick lists dynamically

Excel - How to build pick lists dynamically

Here's worksheet A:
Parent Kid Age
------ --- ---
John Scott 5
John Lucas 7
John Elisabeth 12
Victoria Jason 3
Victoria Amy 5
Jenifer Ashely 13
Jenifer Jared 17
And worksheet B:
Parent Kid Team
------ --- ----
John Elisabeth Lions
Jenifer Ashely Sharks
Jenifer Jared Panters
In worksheet B, I want my users to be able to choose the kid's name from a
pick list (using data validation). The values of that pick list should be
driven by the kid names entered for this parent in worksheet A. For
example, if I select cell A2, the pick list should contain:
Scott
Lucas
Elisabeth
Can I do this with a regular formula or should I use VBA?