Excel VBA help please! Hello, the question is asking me to make a button that will copy the data from one worksheet onto another to create a final report. Its says the report should organize the given data by types of products sold and include only the company name, products sold, and annual sales figures. It also asks for a pie chart using the annual sales with a function feature. Any help would be greatly appreciated. Thank you for your time.

Products dry goods cookware produce paper cookware produce Annual Sales 1 Company Name Sales Rep 2 Quality Foods 3 KitchenWare 4 Daily Market 5 aper Supply en Jo 6 DuraGoods 7 Mom and Pop's Jeremy Todd Donna O'Keefe Ryan Brown Toby Fields Ken Johnson Jacob Stevens Phone 111-1111 222-2222 333-3333 444-4444 555-5555 $52,965.00 $16,432.00 $85,128.00 $14,682.00 $10,254.00 $32,842.00 666-6666