Excel: Expand/Collapse with Data from Other Spreadsheet

[BoydMT]

I have a spreadsheet containing summary-level data. The columns are as follows:
"Department", "Budgeted Hours", "Actual Hours", "Variance", and "Expenses".

I have a 2nd spreadsheet with detail-level data .. "Department", "Employee", "Work Date", "Hours".

What I've been asked to do is display the summary data in the 1st spreadsheet, and include a (+/-) expand/collapse button on each row. When clicked, the detail data for each employee should be displayed below the summary row.

I've tried using the "Group and Outline" feature within Excel, but I can't figure out how to view the detail data that comes from another spreadsheet.

Is this even possible?
Any help is greatly appreciated.

Thanks,
Boyd

 

[fneily]

You want to do a Consolidation spreadsheet. Click the help button and type in consolidate to see an explanation. You would click on Data - Consolidate and fill in the steps. It's hard to explain but here goes:

It would help if all the spreadsheets have the same structure.
Select the Summary sheet. Select the cells the totals will go. Choose Data - Consolidate.
Add the ranges that you want to consolidate in the other worksheets. (eg. Sheet2!A1:A10)
Check the box next to Create Links to the Source Data.
Click OK.
The summary sheet will now have the expansion indicators.