software

is there a way to make worksheets in other worksheets/workbooks and then have
all of that inside another workbook. I need to create worksheets for 3
employees to record their work individually, for example. The information is
entered into employee's worksheet then needs to be put into a separate form
that combines the employee's worksheets collectively for a month's period.
That then needs to be put into a form grouped by year. Is this possible to
do or am I wishing for miracles???

Any help is greatly appreciated.

The folding workbooks scenario that you describe is not possible, but it is
possible to reference another workbook from a workbook, so you could easily
have a master workbook that pulls in the critical data and summarises that.
For instance

='K:\My Documents\Spreadsheets\[Unique Entries.xls]Sheet1'!$A$4

is an example of referencing a cell in a closed workbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;KB-1quot; gt; wrote in message
...
gt; is there a way to make worksheets in other worksheets/workbooks and then
have
gt; all of that inside another workbook. I need to create worksheets for 3
gt; employees to record their work individually, for example. The information
is
gt; entered into employee's worksheet then needs to be put into a separate
form
gt; that combines the employee's worksheets collectively for a month's period.
gt; That then needs to be put into a form grouped by year. Is this possible to
gt; do or am I wishing for miracles???
gt;
gt; Any help is greatly appreciated.