removing duplicate information

i have a large, regularly updated table that contains both columns of numbers and columns of text. i want to be able to have seperate data sheets that would automatically generate, for example, the number of times each seperate year was used, number of times each product line was used, etc..

can this be done in a macro?