Sharing information between worksheets

Ok so I have a number of worksheets inside a single workbook. They are all related to a given customer, each new customer gets a workbook. What I want to happen is when I create a new workbook for the customer I enter customer information onto the Customer tracking document and I want the customers name to appear on several other sheets in the workbook. I also want other customer information to appear on these other sheets including dates, invoice numbers, phone numbers, customer numbers....the list goes on. I assume it is all the same process. I can take values from a cell in another worksheet and apply it to a formula and that works but it will not work for the other peices of information I mentioned. Any help would be great. Thank you

It would probably be best to create a blank template for what you want to do (not necessarily saved as a template, just a workbook that has all formulas but no info). For example, if Sheet2, A2 reads from Sheet1, A1, a simple formula of =Sheet1!A1 in Sheet2, A1, would work and update when you changed Sheet1. For the other pieces of information, this approach will work, you just have to format the cells the formulas are in to be what you want. There are specific date and phone # formats already in Excel and you can do custom formats if it doesn't already have what you're looking for.
If this doesn't help, please respond with a more in-depth explanation of what you need.

Put your customer details into a single database, not spreadsheet, and link crosstabs off it.

Quicker
Neater
Smaller files

CC

Cheeky Charlie
How do I do that?

Never mind I got it figured out. Thanks for the help.