Find/Return/List

[chesbrougha]

-5 excel worksheet organized with the same column headings but different information (A5:CY127)
<br><br>
Column C contains Text Names while column CQ contains data. Not all cells within CQ contain data. I am only interested in rows in which data exists in column CQ.<br><BR>
I would like excel to be able to compile an ascending list. Defining fields and using the index formula could work but I am having trouble figuring it out.

[Cheeky Charlie]

How about using a pivot table?