worksheet data filter
 

I really (1) need some VBA code for these steps:

selecting range A2:G10000 within existing worksheet named "Master File"

then, looking at data in row G and if meets one of the two or three diff.
text inputs (i.e. "Baby Boy" or "Teenager") then it returns only that related
data row in cells A through G and places them in an existing worksheet named
"Children". I want this filtered data to start in cell A7 and the data to be
sorted in ascending order to data stored in Column D from the original
selected range.