Collecting a column from several sheets into one column

[PSmithson]

Hi,

I have 12 sheets, January, February etc. Each one has a date in column A. I'd like to create a new sheet with all the dates in all the sheets. So something like

='January'!A1:A99 + 'February'!A1:A99 + etc

Also there isn't really 99 entries. I only want the rows that have been filled in.

Is there a way to do this?

Thanks.

Peter.