Hi,
Save workbooks in an arranged workspace
When you open a workspace file (workspace file: A file that saves display
information about open workbooks, so that you can later resume work with the
same window sizes, print areas, screen magnification, and display settings. A
workspace file doesn't contain the workbooks themselves.), Microsoft Excel
opens each workbook saved in the workspace.
Open the workbooks you want to save in a workspace.
Size and arrange the workbook windows as you want them to appear when you
open the workspace.
On the File menu, click Save Workspace.
In the File name box, type a name for the workspace file.
Tip
To open the workbooks each time you start Excel, save the workspace file in
an alternate startup folder (alternate startup folder: A folder in addition
to the XLStart folder that contains workbooks or other files that you want to
be opened automatically when you start Excel and templates that you want to
be available when you create new workbooks.). Save only the workspace file,
not the workbook files, in the alternate startup folder.
**********************************************************
For more information, please refer to the following topic in the Microsoft
Excel 2003 online help:
"About consolidating data in multiple worksheets "
Challa Prabhu