Problem in Merging Information

Hi,

I'm not sure if this is possible, because I have a working file where in I have a sheet for RAW Data (Information from PDF), then once I click the button It will merge the specific data in Result Tab.

The problem here that details is not constant. Usually when I paste the information the Customer Name is located in ODD number of cell. I also included Legends for the location of the information that I need to capture.

Please see attached file for references.

I hope can someone help me with this project