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

Please Login or Register  to view this content.

Imported Data

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

Thanks Caracala, but unfortunately ChooseCols not available in office 2021

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

Thanks Ali. It works perfectly