Hello

I have a spreadsheet where 1 page records all the sales data relevant to the business, date, client, salesperson etc

What I am looking to do is to have the subsequant shhets in the workbook collate only the relevant sales information for the individual salesperson, i.e. if I have 8 salespeople, there will be 9 sheets in total, my main sheet with all sales recorded and then the 8 individual salespersons information.

Is there a way to have the individual sheet search the main sheet for the individual salesperson and then copy that information over. I have been playing around with some if statements (the extent of my knowledge with excel), and cant seem to get it working too well.

Any help would be appreciated.

Sincerely
Trilogy