Automatically populate worksheets if data in column 1 matches

Hi,
Is there a way that I can automatically populate information in certain columns of worksheets 2, 3, 4, etc when the data entered into column A matches the data entered into column A on worksheet 1. I have attached a sheet showing the different headings on my worksheets (all in the same workbook) and an example of where the info might be duplicated. I have coloured the relevant columns in bright green.
i.e. if I enter company3 onto the second worksheet in columnA I want the data in columns BCDEF copied from worksheet1 (where the column headings match).
any help gratefully received.
I am using excel 2003
many thanks
carrach

I would recommend a pivot table but a formula might look like:

=INDEX(new_clients!$A$4:$AE$9,MATCH($A3,new_clients!$A$4:$A$9,0),MATCH(B$2,new_clients!$A$4:$AE$4,0))

Index returns a value from an array based on coordinates, so if you have a table:
| 1 | 2 |
| 3 | 4 |
the formula =index(<table>,2,1)
will return 3 (i.e. row 2, column 1)

In the index formula are two match formulae, each one uses the relevant identifiers to find the correct coordinates:
if you have a list: {a,b,c,d,e,f}
match(d,<list>) returns 4

Hopefully you can see how these fit together.

For future reference, there is an 'evaluate formula' tool in the Formulas section of the ribbon. It doesn't look all that special, but it's brilliant for getting to grips with this sort of thing.

HTH