Required fields pop up message when trying to save/close

I would like to have a pop up message for required fields when users are trying to save/close the spreadsheet

However, I have 3 worksheet tabs of required fields

The same excel file is to be shared by 3 different users, that will use their own specific worksheet tab. (Operator/Forklift/Maintenance)

The guy I'm doing this for insists on only 1 excel file because the users might have to do work in other tabs if someone is not at work.

Is it possible to have a pop up message on each tab and it not conflict with the required fields on the other tabs?
For example, work is only entered in Operator tab and not the other 2 tabs.