Macro to Filter Information in Multiple sheets and Make graph

[misschanda via OfficeKB.com]

Hello,
At the end of the year, sales data per customer is needed based on the
products they have purchased. Would like to design a macro that filters
through for customer, the particular products, for the given year and return
a graph.
Is this possible
thanks
la