Thanks very much Biff, works a treat but I cannot follow why it works,
Many thanks
Peter
"T. Valko" wrote in message
...
One way:

=IF(A$1="","",IF(INDEX(INDIRECT(A$1&"!C:C"),ROWS($ 1:1))="","",INDEX(INDIRECT(A$1&"!C:C"),ROWS($1:1)) ))

Copy down as needed.

Biff

"Peter" wrote in message
...
I wish to copy a column from one of several worksheets to a summary sheet
dependant upon the month.
EG. If cell A1 in the summary sheet contained January I would wish to
copy column c from the January sheet to column b of the summary sheet.
I really could do with some suggestions on how to achieve this.

Thanks in advance
Peter