onclick - VBA - populate cell from different sheet on mouse click -

the problem facing is, require cell autopopulate cell reference in different sheet within same workbook when user clicks cell.

e.g. 1) user clicks a1 on sheet 1 2) cell a2 on sheet 1 populates value cell a1 in sheet 2

i need function span approximatly 80+ references, in other words have list of on 80 project names in sheet 1 a1= projectname 1 a2= projectname2 , on. sheet 2 has of project descriptions...a1 project1 descroption..a2 project2 description , on.

i believe looking worksheet_selectionchange event.

in sheet selecting add following:

private sub worksheet_selectionchange(byval target range)    if target.column = 1      ...    end if end sub 

this method gets called anytime select new cell.