Hi Excel Gu-ru's. I am using Excel 2007. Could any one please help

an old bloke who is out of his depth. I have multiple work sheets of

prime and slave configuration containing cells with text headings, and

cells with financial data formula's. All need to be set up with the

same headings etc. A further requirement is that when at a latter

date I wish to change headings or data in the prime sheet, the

corresponding headings and data in the slave work sheets need to

change automatically along with the prime sheet. As there are many

cells to initially set up it would save many hours if I could use a

formula that I could paste and fill. A further complication is that the

headings and data in the prime sheet will be in columns and need to

be transposed when pasting and filling to cells that are in rows in the

other slave work sheets. Any help or suggestions would be

appreciated.