copy data from cells in a column on one worksheet to a single cell in another worksheet

Greetings,
I am working on a calendar. I have data for each day of the month on one worksheet. Each day has it's own column.
I need to copy the cells data for each day (A1:A10) into one cell on the calendar tab (A5). Based on the day of the month.
If there is overflow for the height of the column I would like to create a scroll bar or a hover bar to magnify for viewing on the tab and a shrink to fit the cell contents for printing.

Any help would be greatly appreciated.

Thank you,

JPS

Thanks, I'll give this a try and let you know how it turns out
JPS

Thank you, your code works well.
However, I probably should have been a bit more descriptive.
What I need as a separator is a "soft return" to have the data appear stacked.
Have a great day
JPS

Thanks, that was the key.
Now to work on getting the data from the 28 to 31 columns in the data sheet to the calendar sheet
Thanks again,
JPS