Copy data based on column header from one sheet to another sheet with added criteria

[abhirupganguli123]

Dear All,

Can anyone please help me with the VBA code for the below requirement ?

I have a workbook with few sheets in it. I want to copy data from "Detailed" sheet to "Summary" sheet according to some selected column heading in row 2 of the "Summary" sheet. The same column heading are available in "Detailed" sheet as well in row 3, but columns are more in Detailed sheet. Below are some additional criteria that need to be taken care of.

Criteria 1 - It should only copy data from the rows of the "Detailed" sheet which has the cell value "Sub Total" in column 1 of the "Detailed" Sheet.
Criteria 2 - After copying to "Summary" sheet, it should sort the "Summary" sheet data according to the last column value (currently column 7 as per my sheet).

If anyone can help me with the code, I will be really thankful.

Thanks,
Abhirup