Count, calculate, and graph sales of unique items over time

My company has a catalog of ~6000 unique SKUs that we sell online. Currently we do not have a way to quickly determine how much a given item has sold month over month, and the rate of that change.

I have an excel workbook full of our last year's worth of sales data. I have organized it by placing each month of data in its own worksheet. I would like to be able to create a search box that will allow us to enter in a product ID, and have excel then create a graph with each month's of sales for that particular item. Is that clear? How should I go about doing this?

Thanks!

To follow-up, each worksheet has a field corresponding to:

• Top Level Category
• Product ID
• UPC/SKU
• Description
• Quantity Sold

It seems to be that I really only need the Product ID and Quantity Sold to do this, although I'd like to keep the other fields tied to the results if possible.