Excel Paste Picture Link Macro?

[cosmicchris]

I need to write a macro to paste picture links from one sheet to another in MS Excel.
This is not difficult to accomplish for a once only task from the same location in the source sheet to the same location in the destination sheet.
What I want to do is automate the operation with a macro which will prompt the user to enter the start cell in the source sheet and the destination cell in the destination sheet. My VBA skills are somewhat rudimentary but since I use it infrequently I can't justify a training course. This is what I've managed so far with the macro recorder. As you'll surmise the active cell has to be correct in each sheet and this makes it a chore for the user.

Sub
Sheets("Data&quot.Select
Range("C2:E3&quot.Select
Selection.Copy
Sheets("Trans&quot.Select
ActiveSheet.Pictures.Paste(Link:=True).Select
End Sub