Create a set of excel templates

Avg Bid (USD)
$19 / hr
Project Budget (USD)
$2 - $20 / hr

Project Description:
I am looking for someone who is an expert in Microsoft Excel. With work I have designed a set of spreadsheet concepts I want to happen, I just don't know how to actually make it happen.

The idea is that data would go into 1 certain spreadsheet on a daily basis for the days activity from all of the staff (Annexure 1) This would have the number of cars washed and number of car washing products sold for each staff member for each day over a 2 week period. As a result of entering that data each staff would then have 3 other spreadsheets that would automatically update, 1 being a summary of their activity over this period, 1 being an invoice for car washes done and the other being an invoice for car washing products sold - these would be produced at the end of the 2 week period.

The Annexure 1 spreadsheet could see up to 100 staff members listed, with each week new staff being added to the list (and as such we would need the other 3 spreadsheets automatically being added and updated)

I want to be able to edit the headings of the rows and columns as I will duplicate the excel file

Hours of work: Unspecified Project Duration: < 1 week Skills required:
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: Annexure 1.pdf
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$20 / hr
Hours: 3 hr/ week
$29 / hr
Hours: 10 hr/ week
$22 / hr
Hours: 3 hr/ week
$11 / hr
Hours: 5 hr/ week
$16 / hr
Hours: 14 hr/ week
Hire mgreenwell
$22 / hr
Hours: 3 hr/ week
Hire absrads
$15 / hr
Hours: 8 hr/ week
$20 / hr
Hours: 3 hr/ week
$15 / hr
Hours: 40 hr/ week