How do I make values in a cell in one worksheet move to another worksheet

Thanks Holger,

So I have pasted the code you gave me into the editor for the worksheet I'm working on and enter values into the cells I need to have moved but it does not move them to the Task Summary page

Am I missing a step?

And just a note I sent just a sample of page which is why there was no data on the real page I need it to be B24 trough B40 I did adjust that before I added to editor

Thanks for your help

Also I need it to triger the move if there is a value in cell greater then 0 it could be 1, 67, 84 etc if there is a value placed in cell it needs to move