Need to import 4 sheets from 50+ workbooks into a summary sheet

[JabirS]

Apologies if I'm not explaining this well; I'm a novice at VBA.

I need 4 sheets to be extracted from 50 workbooks and copied into a summary. The VBA needs to work in the background. Can anyone help. I wore this code but it's
clunk and doesn't repeat.

Sub CopySheetFromClosedWB()
Application.ScreenUpdating = False

Set closedBook = Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")
closedBook.Sheets("Sheet1").Copy Before:=ThisWorkbook.Sheets(1)
closedBook.Close SaveChanges:=False

Application.ScreenUpdating = True
End Sub

 

[NdNoviceHlp]

Hi JabirS. So 4 sheets from each of the 50 workbooks? What are the sheet names? Where are the files... all in 1 folder? Dave