Select sheet inside or outside other select

This seems to be quite a unique problem I have, maybe it is a simple problem that no one else has.

I am trying to copy a value from one sheet and paste it to another sheet but I can not figure out where to put the Sheets("OrderData").Select.
If I remove it completely then it copies the values to current sheet, OrderForm, because Sheets("OrderForm").Select was used previously.
As soon as I try and place the OrderData.select in it doesnt work.

here is a snippet of my code.

Please Login or Register  to view this content.

I have the Sheets("OrderData").Select currently commented out where I assumed it would usually go.
Hopefully I have covered everything, I am a bit tired after spending many hours trying this so please excuse my noobishness.