Add multiple ranges to an array then paste the data

Hello,

I am new to arrays so this may sounds stupid but I'll go for it. The attached workbook is a test data dump I receive on a monthly basis that includes more columns than I need and I must format it. My plan is to loop through the top row that includes the title descriptions and search for specific column names. If a name matches then I set the range of the column area. Since there are a number of columns I figured I would loop through and add the ranges to an array and at the end paste just the columns I want to another location (for example sheet2 range A1 for instance.

Can this be done? I would perfer to do it this way and not delete column.

Thank you!