VBA to search column of letters and for that letter searched return letter below it to

Hello, I have data in column C that is similar to 1-15-A. So I want to search through this unlimited data by placing the letter A one cell above the data in column C and run a search it will look for all the data with the letter A in column C and return the data found below the letter A into column D, going down the column . keep in mind for each A found it will return the next letter below the letter A found, then it will go to the next letter A it finds and returns that letter below that A and so on. It doesn't matter what letter it is, so if if runs into an A and there is an A below it it will return that to column D then will continue from that letter A and return what letter below that. Thankyou!