copying specific details in other excel sheet

[@bobby23]

Greeting

Can i ask how to copy specific details in other excel sheet, kindly check my table as attached for any help sir.
Like if i enter student it will automatically copy in other sheet

Hope for your help.Thanks

 

[vletm]

@bobby23
What are Your specific details?
To which sheet do You enter student?
... there seems to be links to external file too.