Excel spreed sheet building

I have some work, in an Excel spreadsheet. 6 separate sheets split into different categories that will all be pulled into an overview sheet were I can view multiple graphs. On each of the 6 sheets I will need the following - -20 different small grids were I can enter employees information Name Length of service (pull to graph on overall sheet) Areas that they have being trained on(pull to graph on over all sheet) 6 options Time since last one 2 one with me (pull to graph overall sheet) Areas for improvement( 6 options to pull through to overall sheet to graph) And finally on the small grid a line on each staff information grid to enter in projects that may be handed out. Also I want an extra sheet for Managers with the same above information but I want it to be pulled into a separate overall sheet with its own graphs etc.