LOL - I just really need an answer!

"Another spreadsheet" is only significant because it's located in a different directory from the original, not just a tab in the same workbook.

The order isn't important, they just all need to be consolidated into 1 column. The original has multiple columns (about 243?) of about 45 rows or less. In the final spreadsheet I just need one column with however many lines it takes to list all of the red cells.