Also posted under WORKSHEET FUNCTIONS

Dear all,

Set-up: I have created a template using Excel to manage projects for our
clients. The template contains a budget forecast, invoices to be generated,
an expense tracking worksheet and a budget reconciliation worksheet. I use
the template for each new project by saving it as a stand-alone document
named for the client and project in question.

Need: I now wish to create a Master Spreadsheet that can track all projects
throughout the year. My goal is to be able to review invoices, budgets,
profits, etc. at a glance through the Master Spreadsheet. I know I can go in
and manually get the information, but I am hoping this can be done in a more
elegant and automated fashion. In essence, whenever I use the template for a
new project, I'd like the pre-determined information I enter in it to also
automatically be captured in the Master Spreadsheet.

Any suggestions?

Many, many thanks,