Hi,

I have same format workbooks in a folder.

I would like to combine one specific sheet into one workbook. But i have to do this for multiple folders, so is it possible to do this with an vba?

I have a code that combines all OPEN workbooks, but i would like to combine all workbook in this path without opening it.

Sub GetSheets()
Path = "C:\Users\dt\Desktop\dt kte\"
Filename = Dir(Path & "*.xls")
  Do While Filename <> ""
  Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
     For Each Sheet In ActiveWorkbook.Sheets
     Sheet.Copy After:=ThisWorkbook.Sheets(1)
  Next Sheet
     Workbooks(Filename).Close
     Filename = Dir()
  Loop
End Sub