Excel sheet automation need help

Hello,
Dear Concern
i am a new user of Microsoft excel. i need help from you. my case is below.

• • in a excel file i have 4-5 sheets with same table & information. i want to put information in any one of sheet and it should be automated copy other sheets.

i need help. if required i can sent the file to you if u give me the mail address.
regards
Joni ....