Merge multiple XLSX files into one

Hi all,

I’m trying to merge a bunch of XLSX files into one (all have the same number of columns and column headers). All files have columns that are filtered differently, so i only want to copy the filtered data. Is this possible? Code i have so far:

$ExcelObject=New-Object -ComObject excel.application
$ExcelFiles=Get-ChildItem -Path C:\Users\filePath...


foreach($ExcelFile in $ExcelFiles){