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.
Bookmarks