Open a workbook & copy data using

[malik641]

Are you combining all the sheets into one specified worksheet? Or are you copying each sheet individually and making new sheets in the main workbook you are copying to?

If you're looking for the syntax to copy a worksheet from one workbook into another, you could look at this:

Workbooks("Workbook_To_Copy_From").Worksheets("Sheet1").Copy _
        After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)