I have been stumped for some time on this problem. If a row of data on sheet1 begins with a given salesman's name, then I would like certain cells from that row to insert into the next available row on that subsequent sheet that corresponds with that salesman.