data is always in different cells

I get data everyday and i need to cut and paste data from one workbook to another, the problem is the data that comes in, is always in a different row.

Is there any vba code that can find for example on Monday it says "ct" in a1 and i need the data from d1. But on tuesday "ct" is in a4 and i need the data in d4.

I look forward to your help, thanks.

Do you have any sample code, i am new to the vba side of excel.

Thanks