Ladies and Gentlemen this is my problem;
I have a spreadsheet that has 3 tabs for details of sales including profits.
I want to create a commission sheet for each salesperson and transfer only
the data that relates to that salesperson.

For example, I have a tabs labelled "New", "Used" and "VAT Qualifying".
These tabs are basically the same and include the name of the salesperson,
name of customer, stock number and profit amongst other things.

The other tabs I have are for the salespeople's commissions and needs to
read the dat from "New", "Used" and "VAT Qualifying" and copy over the date
that relates only to a specific salesperson. i.e. tab 1 is "MM" and should
only have details of sales made by "MM" including the name, stock number etc.

Be gentle with me because I am a bit of a novice in Excel.

Thank you.