Get-ChildItem -Filter *.csv -Path C:ScriptsCSVFiles | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv C:ScriptsCSVFilesCombinedFile.csv -NoTypeInformation -Append