If, then?

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.

I want to track commissions for several salesmen. I would like to enter all of our company's sales on sheet1. column A is reserved for the salesman's name. If I enter a sale for "Tom" I would like that row of data to automatically fill into the next available line of Sheet3, which lists all of Tom's sales.

If I enter Chuck's name in column A, and details of his sale in a row on sheet1, I would like that info to fill in on the next available line on Sheet6, which lists all of Chuck's sales.