I've already started google searching but wondering if someone can direct me
to examples that are a little more specific.

On worksheet 1 I have

Parent Last Name, Parent First Name, Child Last Name, Child First Name


On Worksheet2 I want to create a dropdown list in Column C, D, E (preferable
a list that autocomplete as you type) so that as the last name of all
available Parent Lastnames is in List1 and all possible Parent FirstNames is
in List2, once I know the parent I want List3 to contain all of the children
that parent has registered.

1) Is there a way to do this in excel or should I be looking at VBA samples?
2) Am I looking at using recordsets or do I need to loop through all
entries?
3) Is it possible for me to use SQL Select in VBA or excel?