Copy data different sheet with multiple columns with same header

I am new to Macros

I have situation where some column headers are repetitive like column Header XYZ repeats n times and column header ABC repeats m times in a table.

When we run a macro we need to copy the data from all the required columns to a location in new sheet based on column name criteria