I have looked up several books but can find no reference to this question:-

Is it possible to enter say a column of client names in Sheet1 column "A"
and simultaneously they are automatically entered into Sheet 2! column A or
any column I choose to use? This would save me having to update both sheets
with the same information. I have used this as a simple example but their are
other occasions when I would like to enter data into sheet1 only but have it
automatically transfered to any other sheet within the workbook.

Any suggestions would be much appreciated, many thanks in advance.