Cell linking: Destination cell must perform a search for data

Hello there,

I have a macro which copies and pastes data from cells in one sheet to another.

However, I need one of the destination cells to perform a kind of "search" function in order to remain updated (the data origin cell will not always be the same).

The target cell must be able to find and select the data from the original sheet.
Like this:

Range("*Original Worksheet*!C1").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(0, 3).Range("A1").Select

Can anyone help with this?

I will try and provide as much extra information as I can upon request.
Thanks