fill in value of a cell in another cell on a different sheet if value meant

I am looking for VBA or a formulat that basically if D3=Connect then copy the value in B3 to the next open cell in column D of Sheet xxxx starting on row 3.

will this paste to a separate sheet? I only ask cuz i dont' see where in the code it goes to another sheet. but i am new and ignorant so i am prob wrong.

When I enter the code it highlits the word worksheet and sub or function not defined.

I did that. also will this work on multiple rows?

Thanks alot. I really appreciate it. now I am getting a type mismatch error?

I would but I don't now how to compress it so its small enough.

Furnace Deck Passdown Rev K (Testing)120.xlsm

here you go

A-SHIFT MONTHLY SAFE CARD COUNT.xlsmok its working now sort of. I need it to work for all the cells in range c3-c20 and the current code only returns the value of B3 in the T LINE HEAT sheet.

is there a way to make it work within a range?

Does anyone know how to make this work within a range