Using Advanced Filter to Extract data from certain Columns

I have Headers on sheet "Extract Specified Cols"

I would like to know how to extract the data for these columns from sheet "Imported Data" based on criteria in AA1:AA2 (AA2 is blank as I would like to extract all the branches" , using advanced filter

I have tried using advanced filter but can extract the data from the source sheet

It would be appreciated if someone can provide the steps to achieve this

Thanks for the help John

I only want to copy the cols containing these headers below

Stock Number Ref DESCRIPTION Amount Branch

I managed to resolve the issue

See my code below

 Sub ExtractDataWithAdvancedFilter()
   
    Dim wsImport As Worksheet, wsExtract As Worksheet
    Dim criteriaRange As Range, copyToRange As Range
    Dim lastRow As Long

    ' Set references to the sheets
    Set wsImport = ThisWorkbook.Sheets("Imported Data")
    Set wsExtract = ThisWorkbook.Sheets("Extract Specified Cols")

    ' Clear existing data in wsExtract from row 2
    wsExtract.Range("A2:E" & wsExtract.Rows.Count).ClearContents

    ' Define the range for criteria (AA1:AA2 in wsExtract)
    Set criteriaRange = wsExtract.Range("AA1:AA2")

    ' Determine the last row of data in wsImport
    lastRow = wsImport.Cells(wsImport.Rows.Count, 1).End(xlUp).Row

    ' Define the range where the filtered data will be copied to (A1:E1 in wsExtract)
    Set copyToRange = wsExtract.Range("A1:E1")

    ' Apply the advanced filter
    wsImport.Range("A1:G" & lastRow).AdvancedFilter Action:=xlFilterCopy, _
        criteriaRange:=criteriaRange, copyToRange:=copyToRange, Unique:=False
End Sub

Imported Data

A2=CHOOSECOLS('Imported Data'!A2:H10,1,2,6,7,4)

Thanks Caracala, but unfortunately ChooseCols not available in office 2021

Thanks Ali. It works perfectly

Imported Data

A2=IFERROR(INDEX('Imported Data'!$A$2:$G$10,,MATCH('Extract Specified Cols'!A$1,'Imported Data'!$A$1:$G$1,0)),"")

Copy across