make faster copy paste or formula to assist in copy

I have some data i need to cpy and paste but can't seem to find a formula. In column B there are #s and then word Centrocusto. What im trying to do in column A is copy the names next to the word Centrocusto. im using D9& " "E9 then copy and paste the data.

The problem is the data i copy each time changes and the word Centrocusto shows up every other 5-15 times. I have about 200,000 data. I tried using if, or index, but kept getting stuck. Ive enlcosed what Im doing, any help would be a major dent into what I am doing. THank you soo much!!