I am hoping that someone can help me.

I need some help with copying worksheets. I extract data from an operating
system using Discoverer and then export into excel. These reports are ran
weekly. Discoverer automatically names the workbooks the same name each
week. There are five workbooks.

I would like to create a macro that copies the Worksheets(1) of each of the
five workbooks into one workbook (as separate sheets). I would like to
specific the files and files path in the code (not using a browse option).