I have a worksheet where one cell is basically where information is
dumped into it from another cell. I want to have the cell that has an
issue be numbered 1,2,3 and be dumped cell with the numbers. Is there
a way to do that?

For example:
Cell A1 has Missing file
Cell A6 has No Coverage
Cell A20 reads 1. Missing file. 6. No Coverage.