See Ron's add-in:
http://www.rondebruin.nl/merge.htm

--
Best Regards,

Luke M
"jydoug" wrote in message
...
Is their a way to combine several different spreadsheets with multiple
worksheets into one file. I want one large file that you can open and
view
several different reports at the same time.