Excel Commission Auto Calculator and Hourly Calculator - For Sales Reps

We have a basic Excel spreadsheet with all of our agents having separate sheets to track their hours worked, how many sales they made, and any bonus given. We are growing from 50 to 150+ sales reps. We need an Excel spreadsheet to subtract the 30% from the 100% $2.00 commission per sale in a column that regularly updates. The 30% is paid at the end of the contracted period and needs to auto-calculate and update a sum total per person, weekly. We need hours auto-calculate $10.00 per hour for a sum total per week. We need the sum total of hours and 70% commission to be summarized per weekly pay period. Then we need all bonus money auto-calculate and update at a sum per person. We need the Excel file to auto-calculate the splits and totals and summarize and update each individual's information into a master sheet. This way we can keep the sheets confidential when sharing with the agent, and have an master sheet for management to work with. Upon review this will likely require Active X programming which is beyond our scope of knowledge. Total of 150+ agents and 17 possible columns on the master sheet that need to be programmed to automatically transfer to from the individual agent sheets.