Hi,
I need to copy individual excel files and create a single workbook with each file as a worksheet tab. the original files have only one worksheet each.
Is there any way to automate this process, since I need to do this on a weekly basis with around 20 files? If this has already been...