Runtime error 1004 Application defined or object defined error

I dont know why i am having a lapse in brainwave activity but I cannot figure how to set the variable source worksheet = to the workbook source 1st sheet. I am looking to go into a named file folder and extract data from variable named file folders that each contain .xls files and copy and paste all copied data to the same new worksheet. My code breaks down and throws an error at the same location. If anyone can advise how to reference the first sheet using the set property that would be greatly beneficial. Below is a snippet of my code and the last line is where it breaks

Please Login or Register  to view this content.

Hello detcityced,

The problem is probably in the way you are referencing the worksheet. "Sheets(1)" will return the sheet that is in the first position of all the sheets in the workbook. The Sheets collection includes Charts, Macro sheets , and worksheets. If you want to return a reference to a worksheet named "Sheet1" then you should reference it like this: Worksheets("Sheet1").