Excel Timesheet - VBA

Hi, I have a timesheet that I need automating, I have already started it, I can email a copy as it won't allow me to attach. I would like the below functions: Timesheet in Excel one timesheet/file per employee. File to only be opened by employee & approver, require username & password, one for employee and the other for Approver, other employees should not be able to access other colleague’s timesheet that are kept in the same file location in share drive. Employee to enter the timesheet and then submit for review. On Submit – email to be sent to approver and secondary approver. Approver to then login into timesheet and either Approve – which will then lock that timesheet from being edited and save a PDF copy into drive, and for a new timesheet for following week to be created. And to send email to employee with timesheet status that its been approved. Rejected – This will send email to the employee to say it’s been rejected and in body of email to be text with reason (user input). Once the timesheet is approved I need all the timesheets data to be transferred to another excel file that has been set up as a table in order to run pivot/Queries. Please note we use share point.