Copy data from one sheet to another

[taufiq_786]

Hi,

I urgently need help to design a macro which can copy data from one sheet to another.
but its not that simple.
the data in sheet 1 can be in any column and any row but has to go in a particular column and row in my destination sheet.

Example.
in sheet one from where i want to copy a a amount under heading revenue in column D and row 4 to my destination sheet where that data has to go in same heading but different column say G and different row say 8.

how can this be achieved.

please help me out on this.

thanks
Tofiq G