Automating Excel spreadsheet

I have an excel spreadsheet that I enter hours for each employee, subdivided by client. (One employee can work with multiple clients, and each client can have multiple employees working with them). Then on another spreadsheet I have to reenter the hours each client received. --I need this to be done automatically when I enter it the first time on each employee. --And put it in the correct space. I enter mileage multiple times also in a similar way since each employee must be paid for the total miles but it has to be charged to the client. I need to be able to add employees and clients into the spreadsheet. Therefore the formulas must be tied to the employee name rather than their spreadsheet location. Interested freelancers must submit a sample of excel spreadsheet where you did similar work. This will help me Identify that you realize what I need.