You really should give some consideration to the well-meaning people on this thread who tried to help, and for at least one solution you received from me that does exactly what you want. You can't expect to wave a magic wand over the computer for it to grant your wishes, computers need a little coercion.
Try these steps, and post back if you get stuck:
(1)
From your worksheet, press Alt+F11. That will take you to the Visual Basic Editor.
(2)
The left pane should be visible, entitled "Project - VBA Project". That is called the Project Explorer. If it is not visible, hit Ctrl+R.
(3)
Find the bold type name of your workbook in the syntax "VBAProject (YourWorkbookName.xls)". Click on it once to select it.
(4)
Click on Insert > Module.
(5)
Paste the code I sent you into the large white space in the pane on the right that is the new module.
(6)
Press Alt+Q to return to the worksheet.
(7)
Click Tools > Macro > Macros...
(8)
In the larger white box of that Macro dialog box you will see "Test1". Double click it, or single-click it (that is, select it) and press the Run button. Either one of those two actions will run the macro.
Finally...
This macro works, I tested it just now on my computer, which has about 3,500 Excel files on it. The macro took 2 minutes to run with that many files, so if you have as many Excel files as you imply, then be patient while the macro is running. And remember to turn on your printer before running the macro.
