Copy to a Database sheet with VBA
Merge cells from all or some worksheets into one Master worksheet
Create a summary worksheet from all worksheets (formulas with VBA)
Create a link to or Sum a cell in all worksheets (worksheet functions)
Create separate sheet for each horizontal PageBreak
Copy records with the same value in a column to a new sheet or workbook
Create a workbook from every worksheet in your workbook
Merge data from all workbooks in a folder
Merge data from all workbooks in a folder: RDBMerge Add-in
Change cell or range in all workbooks in a folder
Create a summary worksheet from different workbooks (formulas with VBA)
Merge data from all workbooks in a folder in a txt file
Copy records with the same value in a column to a new sheet or workbook
Create a workbook from every worksheet in your workbook
Merge all CSV or TXT files in a folder in one worksheet
Copy every TXT or CSV file that you select in a new worksheet
Merge data from all workbooks in a folder in a txt file
Copy a range from closed workbooks (ADO)
Copy data from an Access database into Excel with ADO
Copy and Move files and folder
SpecialFolders and Windows Temp folder