How would I select a range from column C to column E to the end of text
(all rows down where there is text), cut and move down 2 rows to Row 3, over
to column A and paste through all spreadsheets that have information?

Then delete row 1 in each spreadsheet?