Good day, to all of you.

I need help on search function, it maybe a simple code or a macro, but I don't know how to enter macro on excel.

here's the details:
filename= "teacher_evaluation_data_201206.xlsx"
sheet name = "20120601-30"
Column A to L has data on it

first problem
1. search for a name on ("sheet 20120601-30", column D) and list all of the rows found with the same name on a different excel file. separate excel file for every name (if this is possible)
*sample filename for name "debbie" is debbie.xlsx

second problem
2. search for a name on ("sheet 20120601-30", column D) and list all of the rows found with the same name on a separate sheet. separate sheet for every name

*sample name on column D is Debbie or Dustin or Kumiko

sample source sheet
A------------B-------C-------D-------E------F------G----------H----------I----J----K----L
6/1/2012 11:00 Around book Dustin banks self attendance working stud filer boy 19 forest
8/21/2012 11:00 Around chair Debbie bricks self attendance workingstud filer girl 17 land


***sample output
A------------B-------C-------D-------E------F------G----------H----------I----J----K----L
6/1/2012 11:00 Around book Dustin banks self attendance working stud filer boy 19 forest
6/11/2012 11:00 for book Dustin banks self attendance10 workingstud4 filer boy 19 forest2
6/16/2012 11:00 Around3 book Dustin banks self attendance13 working stud23 filer44 boy 19 forest5