Problems linking numerous sheets in workbook to one master sheet

**Joanne2013** · 03-15-2013, 05:33 AM

Hi All,

Hope you can help?

I am working on multiple projects. In the attached workbook I have set up separate excel sheets for each project. I have a master sheet (first sheet) which is a summary of all the other sheets. Basically I would like to show on this master sheet the 'Start on Site' dates for each project so that we have an overall summary on one page. Is there an easy way to do this? I know I could just click in the cell and put '=' but that would take a while to do for everyone.
Information in the numerous sheets will be updated regularly so the information pulled through to the master sheet would need to update also.
Hope that makes sense?

Thanks very much.

**arlu1201** · 03-15-2013, 05:36 AM

Your attachment didnt come through -

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.