Hi
I would like to transfer information automatically from column c of all sheets to sheet 1 coloumn a, b, c etc .
e,g sheet two column c to sheet 1 coloumn a,then from sheet 3 column c to sheet 1 column b, sheet 4 colomn c to sheet 1 colomn c.. up to sheet 50 .
I would like any changes to sheets 2-50 to automatically update sheet 1 .
Is this possible ?your help is greatly appreciated as always .
Bookmarks