|re: I want to copy and pase sheet 3 of every excel files to a new excel sheet so that the new excel sheet contains the sheet 3 of every excel files. |
A sheet is a single sheet within a workbook. A workbook is a file that can contain one or more sheets.
You said that you want a new Excel sheet. Do you want to create one big sheet with all of the data from the other Sheet 3's in that sheet or do you want to create a new Workbook containing all of the Sheet 3's as separate sheets?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.