calculate multiple worksheet totals then invoice

*sorry i meant to say workbook rather than worksheet totals in the title.*

hello, I am very new to excel hence why i am here. i have made very simple worksheets in the past for simple printing but thats as far as my excel knowledge goes.

what i am trying to acheive is this,

A friend who has a small civil engineering company has asked me to try to automate some of there paperwork tasks they get daily.

an example of where i think excel could be used is here:

an engineer on site fills out a predefined work sheet with for example: hours and consumables(more fields will need to be added) used that day on his laptop. this information is emailed back at the end of each day to the office where a normal job folder is held and updated.

this work book is stored in the appropriate folder.

at the end of 5 days there would be 5 separate work books with the data on from the engineer/engineers.

my idea is to have excel automatically merge?/overwrite?/calculate the data in each field for the workbooks day 1, 2, 3, 4, 5 data totals into one invoice sheet for the office to print and email off to the client.

can excel be manipulated to this? and for my next question where do i start