linking worksheets; excel 2003

Hi I have a number of separate worksheets in one spreadsheet all based on the same list (eg customers); the customer's name is the first
column and hence the 'key' in each worksheet; when I insert or delete a line in the main worksheet the formulae in the first (customer name) column are amended in the other worksheets BUT I ideally need more than that; when I insert a new customer in the first (main worksheet) I need a new line with that customer name inserting into the corresponding place in the other worksheets; and when I move a line (eg delete a customer and move them to the bottom of the main worksheet list) I need the corresponding lines in the other worksheets moving as well. I guess what I really need is a drill-down function; a main customer list and sub-lists all linking back to the main lists like you would get in database tables. Does anyone know if this is possible ?

Hi, so kind ..
I have an incredibly simplistic test spreadsheet without real data and without the majority of the formulae and calculations held in my real spreadsheet. It only contains 2 worksheets and only a few records; but would that be enough ? Jane
ps I am new to the forum and don't know how to attach this is my reply ?