How can i make link to different sheet
 

Dear all.

i have 5 excell sheet,
1 - work unit rate employee list
2 - time unit rate employee list
3 - schedule employee list
4 - Aramco employee list
5 - All employees list ( work unit + time unit + Aramco unit + Schedule )

My quetion.
1. I would like to make link all sheet. How can i do it?
2. when i add new emplyee records, it should go to relative unit sheet.

So please help me, We don't have ability about access.
Your cooperation is highly appreciated.

Thanks
irsath mohammed