Excel Expert

I have a report that analyzes sales performance of my sales team in a restaurant. I need a excel expert to design an executive dashboard, using the data that we have. The dashboard either needs to be created in a separate file, that pulls the data from the report file (as the report file changes daily) The dashboard needs to outline, in detailed colorful info-graphs, how the waiter is preforming, amongst their peers and others in the group. The report I have already gives us all of this information, I simply want to make it more relevant and easy to read for the waiter. Each waiter should have their own report, on a separate Sheet , printable onto A4 paper. So: here's my view on the work flow. 1. We get these reports emailed / linked to us every day at 11am 2. We save this report into a folder called "Waiter Reports" 3. You design a excel template, that does the following a) See's how many employees are listed in the Report b) creates a separate sheet in Excel for each employee c) inserts a dash-board that compares the employee to every one else in the restaurant, an give KPI's on sales / average spend per head etc ( we have all of this data) d) Also compares the employees amongst other restaurants in the group (again, we have this data) d) Relays the information in an easy to use, info-graphical format f) Give the use the ability to exclude or ignore certain data