Can we hide some tabs that show confidential information of the student/staff in update details screen for the specific users?

Yes, the tabs which need to be hidden for the users can be unassigned by the system admin. You can also assign the tabs in the SMS screen for the users based on their role and un-assign the rest.

Path: Settings / Organisation/ Search Tab Settings/ Update Student Details & Update Staff Details * SMS