syntax to search for value on one sheet copied from another sheet

[imagin]

This is for a macro I'm creating. I have everything working except the part that requires the macro to copy a cell from one sheet and then search for the value of that cell on another sheet. The macro starts with the cell I need copied selected.

The sheet the cell is copied from is called TO DO
The sheet the cell is searching on is called OVERVIEW

Selection.Copy
Sheets("OVERVIEW").Select
Cells.Find(What:="FEL3-GB", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

The value of the cell in this example is FEL3-GB but I need the macro to search for the value of whatever cell is copied, not just the one that carries the value FEL3-GB.

Can you help?

[imagin]

Maybe it would help if I included more about what I'm trying to do. Here is the full thing I have now, everything is working except the part about finding the cell copied from the original sheet which I have in bold below:


ActiveCell.Offset(0, -15).Range("A1").Select
Selection.Copy
Sheets("OVERVIEW").Select
Cells.Find(What:="FEL3-GB", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(0, 4).Range("Table1[[#Headers],[Region]]").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = Format(Date, "Long Date")
ActiveCell.Offset(0, 1).Range("Table1[[#Headers],[Region]]").Select
ActiveCell.FormulaR1C1 = "y"
ActiveCell.Offset(0, 1).Range("Table1[[#Headers],[Region]]").Select
Sheets("TO DO").Select
ActiveCell.Offset(0, 15).Range("A1").Select
ActiveCell.FormulaR1C1 = "y"
ActiveCell.Offset(0, 1).Range("A1").Select