Migration Data

I am looking for who can collate different cells' data into one cell from one Google sheet to another. The raw data is coming as Google form responses which have different sections and due to which one field data is coming in different cells due to different sections in Google form.

The formula should not make the google sheet heavy since we will have 3k+ entries in a month