I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam