Dynamic Salary & Expense Tracker

I need to update my current excel sheets to be more robust in order to allow useful business decisions

1. I need 4 Excel workbook that can do things seamlessly: calculate staff salaries and track total compensations per employee.
The salary side copes with several pay structures like monthly salary plus weekly allowance —so the formulas have to adjust automatically when I select an employee. I want clear tracking of allowances and the total to -date with the flexibility to add other categories (travel, supplies, utilities) later without breaking any of the summary totals.
A clean dashboard with monthly and year-to-date summaries, dropdowns for easy data entry, error-proof formulas, and printable reports. easy for a non-technical user to maintain.
A brief online note so I can hand it to the team manager to understand how to use it immediately.

2. Sales and expense worksheet to record daily or weekly sales and have the excel calculate price of each product multiply by quantity sold and give the total daily/weekly sale minus the expenses giving the final net. some of the expenses is calculated using percentage between 2 partners.

3. this is the same excel concept but with different label for 2nd location with the same columns but different location. just different title/Label

4. Again, this is very similar to the 2nd and 3rd expenses are similar yet different. there are some expenses that are captured in the other workbook and not in this one i.e. there are less expenses than the previous ones.

Summary.
3 sales, income and expense excel sheets
1 salary excel sheet
should be able to run reports on each of the criteria and column
Use drop down based on the available preset data.
I will provide my current excel samples after awarding the bid