Via automation for property management worksheet

I am building a shared worksheet for property management. Need to automate some functionality for admin staff. Project should be only 1-2 hours of work.