How to copy a cell from a different sheet with conditions

Hi guys, so what I'm trying to do is: I have a list of data in columns, and for each cell filled I have a sheet with this cell name on it. What I need to do is: Verify if the column is filled, and if yes, copy for the next column, the cell for example "C4" from that sheet.

Example:

A B
P1001 I Want to put this in the cell '='P1001'!C$4" but using VBA
P1002 ='P1002'C$4"

Like if I enter the cell, click equals, go to the correspondent sheet, and click cell "C4".

What I have so far is:

Please Login or Register  to view this content.

I know that is completly wrong, but trying to show my line of thought.

Thanks guys.

You got it! Thank you so much.