GetValues from a Closed Workbook with a conditions/criteria

Hi I have this macro working to retrieve/extract/pull data from an Excel closed workbook. The macro pulls the data based on the range but where I am stuck is how to pull an specific account. Lets say the data set has 5 accounts and I want to pull the data for only one account, what is the If logic I can use with GetValuesFromAClosedWorkbook function if any.

My data set has 5 accounts. I want to pull an specific account lets say P 15178. What the if statment a I need to use in complement with the GetValuesFromAClosedWorkbook function.

See attached file for the VBA code script.

Thanks in advance.
carlos

Why not just add a filter to range A7:F7 in your target sheet and select the specific account you whish to see?

Alf