Want to automate the recording of data from one worksheet to another

Hello

I have attached an Excel Workbook file which has 5 worksheets. The 1st worksheet, 'All Fruit' is the main sheet where all records of fruit sales are recorded. On this sheet I manually enter all transactions which gives me an overall record.

What I would like is for excel to automatically separate out records for each type of fruit and record them in their corresponding sheets. For example, in the workbook that I have attached there is a worksheet for 'Bananas'. I want this worksheet to be able to automatically read the main sheet (All Fruit) and copy only the Row information for Bananas. This will give me separated information for each fruit as well as the overall, combined record.

I have a fair bit of experience using excel, understanding how to create basic IF commands, but this is a bit too far beyond me. Anyone got any ideas? Thanks in advance.

Dan