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