Macro for copying data onto another sheet

Hello,

I have a workbook that contains 8 sheets of different states. These sheets have data of five differenct products' sales and achievements figures upto october 2011. now from november 2011 instead of going into individual sheets and typing data there, i have created a sheet "source". now at first column i typed names of states, then the corrosponding values of actual sales of each state then sheet name (where the value should go) and cell name (where the value should be pasted).
state name nov_actual_sales to-sheetname to-cell


how to do it with a macro?

in a nutshell i want to copy the data of a cell based on the sheet name and cell address given adjcent to it.

please help