Click on cell, populate another in VBA

Good afternoon,

I need help with a Macro in a multi-sheet workbook.

In column A of worksheet: "All Products" I have a long list of product item numbers populating each cell. I would like to be able to click on any of these cells, and have that item number populate cell C3 in worksheet: "Sales Graphs." When clicked, I also want to be taken to that sheet. Can anyone come up with a VBA code for that? I couldn't figure one out.

---------- Post added at 04:05 PM ---------- Previous post was at 04:00 PM ----------

I would like the macro to be compatible with Excel 2003 and newer. Thanks!