Inputing data to populate different tables|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello

I'm not a big excel user and only use basic functions for the most part and I was hoping to get some advice on using excel to a data input table which uses the input data to populate 2 different tables. For example, I work in safety and many of my team members carry out safety audits on a number of different people in different regions. I would like to create 2 tables. One showing who has been audited and on what day of what month. Another showing how many audits each auditor has done in each month and if they have hit their audit targets. 

I was hoping these tables could be populated by entering the data in one table by completing drop down options and hitting a "GO" tab to update the tables with the inputted data. Is this possible to do in excel? (pretty sure it is somehow) and is it a simple or complicated process? Can anyone point me in the right direction as to where I can find out how to do this?

Help is much appreciated

Alan