Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names

Thanks Mike.
I tried the code; for all the workbooks (except the first or last one) it pastes only the first 2 raws. And I need the workbook name not the worksheet name.