Do some Excel Work

Have a template of how individual department staff key in their respective activities for the day and the number of hours they do so. We have a whole bunch of excel sheet entries from different departments in different worksheets. Would like them all to be amalgamated into one interface where - user can key in ID or name, input activities for the day and the number of hours it took.