Gehe zu ersten Excel-Tabelle nach add-Workbooks

$Worksheet=$Workbook.Sheets.Item("Tabelle1")  
$Worksheet.Activate

$ExcelObject=New-Object -ComObject excel.application
$ExcelObject.visible = $true
$ExcelFiles=Get-ChildItem -Path "C:\tmp"  
$ExcelTarget="C:\NewTemp.xlsx"  

$Workbook=$ExcelObject.Workbooks.add($ExcelTarget)


$last_ws = $Workbook.Worksheets.Item($Workbook.Worksheets.Count)
$n = [System.Reflection.Missing]::Value
$new_ws = $Workbook.Worksheets.Add($n,$last_ws,$n,$n)


foreach($ExcelFile in $ExcelFiles){
$Everyexcel=$ExcelObject.Workbooks.Open($ExcelFile.FullName)
$Everysheet=$Everyexcel.sheets.item(1)

$Everysheet.Copy($new_ws)
$Everyexcel.Close()
} 

$Worksheet=$Workbook.Sheets.Item("Tabelle1")  
$Worksheet.Activate
break