With's and end withs sheets and copying.

Okay so I have this code that copies the contents of one cell (A1) and pastes it into anouther (B1). the next time the code is ran, (A1) will be pasted into (B2)
See Code below:

Please Login or Register  to view this content.

I have had to change a few things around due to expanding.

Is there anyway I can do this where The cell that's being copied is on a different sheet than the destination of the paste?


Help please!

Please Login or Register  to view this content.

for example.