Powershell merge CSV based on cell value in a row

I need to merge a bunch of CSV files into one big CSV and selecting only for the rows that contain value "XX" in column 2

I created the script to merge the CSV (that also removes the first 8 lines of the header) but I don't know how to filter the rows to be copied into the merged file with the condition above.

$InFiles = Get-ChildItem -LiteralPath '.\' -File | Where-Object { $_.Extension -eq '.csv' }

ForEach ($File In $InFiles)
{
    $File | Get-Content | Select-Object -Skip 8 | Out-File -LiteralPath '.\out\OutFile.csv' -Append -Encoding ascii
}