Do you actually want to concatenate the text from the different sheets into
one string, or do you want the data from each sheet in a separate column on
the summary sheet?

If the latter, then in A1 on your summary sheet you could use =Sheet1!C1, or
=IF(Sheet1!C1="","",Sheet1!C1) if you want the cell blank where the relevant
input cell is blank. Then in cell B1 you could put the same formula, but
changing the Sheet1! references to Sheet2!, and so on for your other sheets.
--
David Biddulph

"ant1983" wrote in message
...
I have multiple (identical) spreadsheets which are job descriptions for
each
employee in our company.

In Column C i have their "Outputs" (the actual work they need to do).
This
is a text string.

I want to "Concatenate" all of these "Outputs" (Column C's) in each
spreadsheet into a singular spreadsheet so that i have a central place to
go
look (kinda like a logsheet or whatever.

I say it cannot be done without HUGE programming - My boss disagrees. Can
anyone help???

Many thanks,

Wayne