I'm trying to copy from various parts of a succession of worksheets. Everything is in the same file.


My worksheets are named 1,2,3,4,5
I want to copy the contents from C4 in worksheets 2,3,4,5 into column 3 in WS1; then I want to copy the contents from C6 to column 4.

It's been a horror show - I'm dealing with formulas like ='[C3]1'$C$4 and each cell has to vertify the directory & file.

Please help...

Jim Berglund