To get a real answer, you're going to have to be more specific.
Does merge workbooks mean:
1. Copy all the sheets in several workbooks to new workbook (so it ends up with
lots of sheets)
2. Copy the data from all the worksheets in several workbooks to a single
worksheet in a new workbook
Either way, are the workbooks to be merged in one folder? Is that folder
dedicated to just the workbooks that need to be merged? Or do you have some
naming convention that needs to be looked at to see if it should be merged?
===
Manually, you could do each of these things pretty easily--but with lots of
workbooks, it would get boring. If you need to do it lots of times, a macro
would make life simpler--but that macro needs a little more specification.
