ok i'm going to try to describe what i want to do accurately here.

I'm looking for a way to search a column for a specified value and when it
finds that value, which appears multiple times, I want to copy that entire
row into another sheet in a specified area. I need to be able to do this for
mulitiple different values that each appear multiple times in the column. How
do i do that?

In case that makes no sense i'm going to put it another way. I have 56
accounts on a commission report. Each account has a unique customer ID. The
report shows every time they ordered last month, so the same account will
show up many times. I have 5 salespeople. I want to make it so that when i
get a new report i can simply copy it into the referenced sheet (call it
sheet2) and have the sales for that month automatically sort on the sheet
with all my salespeoples names on it (call it sheet1). what do i have to do
to get excel to search column D for C12345 then when it finds it copy the
whole row where it found C12345 (<-- actual format of our customer ID) to
sheet1 in the area i specify.

I hope that this is doable.