Can you explain a little more about the Structure of your information:

You have Customers
And each customer has at least one Plan, do any customers have multi plans?

What are the components of a Plan?
Are all components required in a plan or are some optional?

Do some/all of the components have sub components? If so what are they?

Is it possible to lay out the structure on one or two worksheets without
adding any specific data? If you could do this I would take a look at it.
If interested post back and I wll give you an email address.

"Stephen Price via OfficeKB.com" wrote:

The Information that I have with the customers are that of a plan for the upcoming year. So when I have to add different sheets, that means they have more than one Plan. You can think of it as a Farmer with multible fields and multible crops. Each Plan for each crop will be different, as well as some fields with same crop may not be the same.
Each File is stored by customer name (Last, First). Each file my have the same name on one or more sheets. This is a system that has been used in my company for some time now, and to change it to only one workbook my be quite a challenge. What I am looking for is something I change in the template, and email to all locations without changing procedure.
Although, I will look into your suggestion. That was just my first concern. Even if I don't impliment this idea, I may help in the future.


Thanks for your help.

Stephen

--
Message posted via http://www.officekb.com