Extract Data to New Worksheet

[kimber7]

Hi! I need some help! Your YouTube Video #185 is exactly what I would like to do with my information in my workbook. However, here are the differences in my data. I am working with a company main data file. It contains columns that include customer data. It also contains several columns (currently 10) that list the different products that these customers purchase from us. (For ease I will use fruits). For example:


NAME Phone Number Street Address Product #1 Product #2 Product #3
Joe (123) 456-7890 1234 W. Main APPLES PLUMS
John (123) 456-7890 1235 W. Main GRAPES
Paul (123) 456-7890 1236 W. Main PLUMS GRAPES KIWI
Jack (123) 456-7891 1237 W. Main APPLES KIWI

I have all of the customer data on the main page. Using the "product" columns, I would like to extract the customers that buy apples from us and have that data on a new page titled "APPLES". I want to continue this for all of the other products. My goal is to only update the main page, but be able to look at the breakdown for each product at any given time on their individual pages. I would also like the top of each worksheet to show the product and have a counter of all of the customers that buy "Apples" from us (like you have in #185). Any help would be extremely appreciated!!!