Looping

Hi. I am not sure if my goal can be achieved by just a formula or macro. I would like to copy some of the lines to specific column. Please see attached file for further explanation. I hope this can just be done with formula so that I can easily combined it with my other formulated cells. Thank you.

HTML Code: 

I would like to have a formula or perhaps macro codes to:

1- look for word "BEG". Once found, search the cells below it and look for DTM (above there are 3 lines or cells with DTM. These cells would then be copied to the colum next to "BEG" (refer to attached file).

2- the same process as step 1 but this time for string PO1.
3- the same process as step 1 but this time for string CTT
4- when it reaches the last cell down or blan k cell, it stop the process.

I hope this is clearer. Thank you for viewing and replying to my post. Please help.