Can anyone tell me how to write a macro or code that would automatically copy
the text contents of a cell from Workbook A to Workbook E only if that cell
in Workbook A is not Empty. And if the cell in Workbook A is empty, then
continue to Workbook C, and D?

My ultimate purpose is to include a summary of all the text inputted to
Workbooks A-D in Workbook E. I want to see only the cells that contain text
from Workbooks A-D in Workbook E.