Combining/Referencing multiple cells from another sheet - concatenate?

[nedezero]

I'm trying to combine the contents of multiple cells in worksheet, into a single cell in another worksheet.

It's basically a planning calendar that starts off with weeks, then rolls up into quarters, then years.

So in one sheet called "weeks" I have events planned in cells designated as week 1 (a1), week 2 (a2), etc....

On the next higher schedule which is a worksheet called "quarterly", I want the contents combined into one cell that references a quarter. e.g. Q1 (a1), Q2 (a2), etc...

So for Q1, (in cell a1) I entered =concatenate(weeks!a1&""&a12), but it only brings in the text entered in sheet "weeks" cell a1.

Help!

[arlu1201]

Do you have a sample sheet that you can upload?

[nedezero]

Do you have a sample sheet that you can upload?

Sure, but upload to where?

[nedezero]

I sorta got it to work by typing

=CONCATENATE(weeks!a1, weeks!a2, weeks!a3, etc)

Is there a better way plus insert spaces?

[arlu1201]

Upload your file here. Without looking at it, its difficult to give a working solution.
To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.