You question was clear to me and I believe to Luke.
You asked how to combine several workbooks and their worksheets into one
large workbook.
Luke pointed you to Ron's site for an add-in to help you.
I guess you did not have a look or................?
If you don't want the add-in and are a DIY person see Ron's site here.
http://www.rondebruin.nl/tips.htm
Scroll down to copy/paste/merge examples and choose the code you need.
Gord Dibben MS Excel MVP
On Fri, 9 Apr 2010 10:51:02 -0700, jydoug
wrote:
I guess my question wasn't clear. I don't want to Merge anything. I just
want to have one file to open with several diffent reports in the file.
"Luke M" wrote:
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.
.