Hi All,

Right, I'm looking for a formula that will copy text from column A in
worksheets 2-5 into column A of worksheet 1?

E.G. If another name is added in column A, row 4 of worksheet 3 I need it to
appear in the same column and row of worksheet 1.

Any suggetions? - Be gentle, I'm an excel idiot!

Tomo