I basically have a client information template that my employees can use to store new client information. I want to have this information link to anther excel workbook (or another program if applicable) that summarizes key information about all clients. I don't want to have to enter the data twice. I need to somehow link the template so that any time someone saves a new client information sheet, it populates automatically to the summary database.

Thanks for your help.

Andrew