Copy data different sheet with multiple columns with same header

[Closed]
Report
-
Hi,
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

Thanks