I would like to input a clients name on one sheet and have that cell data
placed automaticly at a specified location on other sheets within the
workbook. Can this be done using a function or do I need to think of
something else? Any help would be great.

Jim