I realise the original question relates to merging worksheets, not workbooks. If in fact there is a need to merge excel files or workbooks, I ran into a handy utility that will merge xls or csv files into one master file. The program, bulk file merger, merge over 240 file in a matter of minutes. What was over an hour now takes minutes.
My answers
Merge Excel Workbooks
I realise the original question relates to merging worksheets, not workbooks. If in fact there is a need to merge excel files or workbooks, I ran into a handy utility that will merge xls or csv files into one master file. The program, bulk file merger, merge over 240 file in a matter of minutes. What was over an hour now takes minutes.