Create a summary sheet

I have a construction co that I have set up a workbook for each project. The workbook contains a project database foe each individual project. Within that database, a summary page shows billings, costs, etc. i would like one sheet to compile or summarize all the workbooks - in other words, have a summary sheet that totals all the jobs (individual workbooks). So my yearly sales and costs are always at my fingertips with one summary sheet totalling all the individual summary sheets.

This is certainly do-able, you can link the cells to another spreadsheet. To do this have all spreadsheets open, click on the required cell press "=" then go to the spreadsheet that holds the information you require & click on the cell that holds the information. This will then display the information on another spreadsheet.

Please note: if the figures change you will need to update the sheet but the sheet will prompt each time you open it, also the link will need to remain at the same directory it was before.

Hope this helps, if you would like an example, please do as TMShucks asks, & attach some examples so we can show you.

Thanks for the help - I think I got it working okay!