Consolidate? or Concatenate? text

I have feedback/text that I need to aggregate into a whole and then summarize ("manually").  Is it possible to consolidate text from the same range of cells on multiple worksheets into one (cell) report?  I've tried the usual approach to identifying the worksheet:cells with numeric data that is to be consolidated, but without an arithmetic function of course since this is text data, but this doesn't work.

 Should this be a concatenation instead?  

Patrice

I am struggling to understand what you are trying to do, perhaps you could expand a little or post an example?

Nick Hodge:

Patrice

I am struggling to understand what you are trying to do, perhaps you could expand a little or post an example?

Example with 2 worksheets, all data is text:

     A           B            C                                        A              B               C

1   lajfljas    halkjhfdl    zpqoyr                          1   lkjhals        alkjhfdlhj     lkjjahlfdhs

2   qreyq     aldflalkh    qoireqwoiuy                   2   iqtoiuy        oiuwqytor    oqytroe

3   qoitre     qoqewro    zmbvcmb                      3   qalkjh         babbb         labqlkh
     worksheet 1                                                    worksheet 2

I need to aggregate all responses to question 1, aggregate all responses to question 2, aggregate all responses to question 3, etc., etc.  This means I need to combine all entries from each row on worksheet 1 with all entries in each of the corresponding rows on worksheet 2 (and all subsequent worksheets).  Using the example above, this means I want a report that gives me:

       A

1     lajfljas    halkjhfdl    zpqoyr     lkjhals       alkjhfdlhj     lkjjahlfdhs 

2     qreyq     aldflalkh    qoireqwoiuy     iqtoiuy    oiuwqytor    oqytroe 

3     qoitre     qoqewro    zmbvcmb     qalkjh      babbb         labqlkh
       worksheet 3

   Excel > Help > Consolidate data in multiple worksheets says "Formulas     You can use 3-D references in formulas for any type or arrangement of data", but all of the Functions available to Data > Consolidate are mathematical functions, so is this supposed to be a Text Function instead, such as CONCATENATE or T? - in which case I won't be able to use 3-D references?

Thanks very much for whatever you can tell me, Nick.