listing from other spreadsheets

[That's Confidential]

I am creating a new spreadsheet which is a summary of the information in
various other monthly spreadsheets which I am linking to.

Now, in my new spreadsheet I want to create a list. Now, I want to link to a
certain cell in the different spreadsheets, and if these cells contain
information, I want this information to be transposed to the cell in my new
spreadsheet.

So for example, in the spreadsheet 'January', cell A1, I have the word
"Apple," in spreadsheet 'February', cell A1, I have nothing, in the
spreadsheet 'March, cell A1, I have the word 'Banana,' in my new cell, I
would only like the words, Apple and banana. I would like this in a list
form, one after the other. I tried doing this in rows, however I had spaces
as some cells didn't contain information and so a line was left blank.

So does anybody know how I can list them so that they appear one below the
other without any spaces appearing?

Thanks in advance